How to count number of values in a dimension for a segment | Community
Skip to main content
dleverentzPT
New Participant
Feb 22, 2023 5:56 AM UTC
Solved

How to count number of values in a dimension for a segment

I'm trying to show the number of unique values/rows in a dimension. Specifically, we collect the UserID of each visitor. I want to show the number of unique UserIDs within a segment. 

 

I tried using the Summary Number visualization, but that sums the values of the occurrences. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jennifer_Dungan
Jennifer_DunganAccepted solution
Level 2
Feb 22, 2023 6:43 AM UTC

Create a calculate metric using "Approximate Distinct Count" function.

 

 

 

 

 

If you want to remove the "unspecified" values. you can also add an on-the-fly segment for "UserId exists" (simply drag your UserId dimension into the calculated metric above the "Approximate Count Distinct" function

 

 

 

 

2 replies

Jennifer_Dungan
Jennifer_DunganAccepted solution
Level 2
Feb 22, 2023 6:43 AM UTC

Create a calculate metric using "Approximate Distinct Count" function.

 

 

 

 

 

If you want to remove the "unspecified" values. you can also add an on-the-fly segment for "UserId exists" (simply drag your UserId dimension into the calculated metric above the "Approximate Count Distinct" function

 

 

 

 

Translate
Alexis_Cazes_
Level 10
Feb 22, 2023 7:19 AM UTC

For more details on count distinct read this article https://www.fullstackanalyst.io/blog/adobe-analytics/cool-approximate-count-distinct-use-cases-adobe-analytics-tips/ it will complement the answer above 

Translate