Expand my Community achievements bar.

SOLVED

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

Avatar

Level 1

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. 

SummaryNumberRows.png

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor and Adobe Champion

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

 

Jennifer_Dungan_0-1677047714326.png

 

Jennifer_Dungan_1-1677047741370.png

 

Jennifer_Dungan_3-1677047862127.png

 

 

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_5-1677048066332.png

 

 

Jennifer_Dungan_4-1677048025803.png

 

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor and Adobe Champion

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

 

Jennifer_Dungan_0-1677047714326.png

 

Jennifer_Dungan_1-1677047741370.png

 

Jennifer_Dungan_3-1677047862127.png

 

 

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_5-1677048066332.png

 

 

Jennifer_Dungan_4-1677048025803.png