How to breakdown "Distinct Count" for a dimension? | Community
Skip to main content
H
H_L
Level 7
November 12, 2021
Question

How to breakdown "Distinct Count" for a dimension?

  • November 12, 2021
  • 1 reply
  • 982 views

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:

 

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

 

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

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

G
Adobe Employee
GarretthAdobe Employee
Adobe Employee
November 12, 2021

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. 

    H
    H_LAuthor
    Level 7
    November 19, 2021

    Thanks for the good idea.

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

    The segment is set to:

     

    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".

     

    If there is further ideas, please let me know.

    Thank you.

    H

     

     

     

    Terms & ConditionsAccessibility statement

    Loading footer...