Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.
SOLVED

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

Avatar

Level 3

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

 

ad.png

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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)

 

 

View solution in original post

2 Replies

Avatar

Community Advisor

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.

Avatar

Correct answer by
Community Advisor

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)