Skip to main content
gkrish12345
gkrish12345
Level 2
April 10, 2023
해결됨

Distinct count calculated metric doesnt add up when broken down by device type segments?

  • April 10, 2023
  • 2 답변들
  • 815 조회

Distinct count calculated metric doesn't add up when broken down by device type segments. Total revenue adds up but not the distinct count

 

이 주제는 답변이 닫혔습니다.
최고의 답변: Jennifer_Dungan

How are those "Desktop Hits", "Mobile Web Hits" and "Mobile App Hits" created / defined?

It looks like you may have overlap between them... 

 

The other possibility is that "distinct count" is a calculated count.. it's not 100% going to return an exact value... 

 

I'm also wondering how you can have "0 Total Orders" in the first few rows, but have an approx distinct order id count... the row clearly shows an order id.... 

 

I can see you are using Demo data... have you tried this report with real data? Sometimes the demo data has some odd issues that you wouldn't get in a real scenario.... One of the Adobe Sandbox demo data suites I've used, I had to create a segment to exclude some problematic data when I was pulling up a sample for illustration purposes)

 

 

2 답변

Krishna_Musku
Adobe Champion and Community Advisor
Krishna_MuskuAdobe Champion and Community Advisor
Adobe Champion and Community Advisor
April 10, 2023

Did you checked the Order IDs, is there any duplicates between the device type segments. I know it's a big process, but it will give you an idea of what segments are overlapping.

- Krishna Musku (Adobe Champion & Community Advisor)
    Jennifer_Dungan
    Adobe Champion and Community Advisor
    Jennifer_DunganAdobe Champion and Community Advisor답변
    Adobe Champion and Community Advisor
    April 10, 2023

    How are those "Desktop Hits", "Mobile Web Hits" and "Mobile App Hits" created / defined?

    It looks like you may have overlap between them... 

     

    The other possibility is that "distinct count" is a calculated count.. it's not 100% going to return an exact value... 

     

    I'm also wondering how you can have "0 Total Orders" in the first few rows, but have an approx distinct order id count... the row clearly shows an order id.... 

     

    I can see you are using Demo data... have you tried this report with real data? Sometimes the demo data has some odd issues that you wouldn't get in a real scenario.... One of the Adobe Sandbox demo data suites I've used, I had to create a segment to exclude some problematic data when I was pulling up a sample for illustration purposes)

     

     

    약관 및 조건Accessibility statement

    Loading footer...