Solved

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

Forum|Forum|2 years ago
February 22, 2023
1 reply
1917 views

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.

Best answer by Jennifer_Dungan

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

Jennifer_Dungan

Accepted solution

Community Advisor and Adobe Champion

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