Distinct count calculated metric doesnt add up when broken down by device type segments? | Community
Skip to main content
gkrish12345
Level 2
April 10, 2023
Solved

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

  • April 10, 2023
  • 2 replies
  • 784 views

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

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by 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 replies

Krishna_Musku
Community Advisor
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.

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
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)