Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How to breakdown "Distinct Count" for a dimension?

Avatar

Level 8
Level 8

Hi there,

 

Would you please help to advise:

  1. How to validate the "Distinct Count" for a dimension?
  2. How to know which values are?

Here is a real example:

We've set segment that Product ID dimension as following:

H_L_1-1636730166890.png

 

A calculated metric is also created: Approx. Distinct. of dimension Product ID

H_L_2-1636730276038.png

 

I understand that the counts is not "2" under "IDs=2" is because, user may visit ID1, ID2 in a visit, also visit ID3, ID6 in a visit.

So the questions come:

  1. How to validate the segment is really include visit 2 IDs?
  2. How to know: if a user visited ID1, what is the other one Product ID the user visited?

Please advise.

 

Thanks!

H

 

 

 

2 Replies

Avatar

Employee

The only way I can think of to validate the 'distinct count' feature in workspace would be, if you have a dimension that can identify a single visitor (ID) and then make a visitor based segment using distinct count.

1) in workspace use the segment which has distinct count
2) filter such that you only see one visitor using your ID dimension
3) breakdown the visitor using the dimension for which you based your distinct count on

 

I would then expect the report to show the distinct values for that visitor and the count should match what is set in your segment. 

Avatar

Level 8
Level 8

Thanks for the good idea.

But then the 2nd question will have no answer, as following screen capture gives:

The segment is set to:

H_L_1-1637332799557.png

 

Then, a table is created, I tried to breakdown 1 product ID by same dimension, but I cannot get "What other Product IDs are visited as well - if a visit viewed PROD500001".

H_L_2-1637332837073.png

 

If there is further ideas, please let me know.

Thank you.

H