Count Distinct

[cgoodman3]

When loading my data in I can see for measures it calculates sum, count and averages for my fields. Is it possible to also create a count distinct. This would be useful for looking at change in customers over time, as I want each customer in the dataset to only be counted once.

[cherylcarrie · Accepted solution]

Hi @cgoodman3! Yes it's possible - you will need to set the column up as a segment (in your case, set up "Customer"/"Customer ID" column as a segment in Admin Portal).

You can refer to this help desk article for more details - under Data Types: Segment.

This way, Auto Insights will automatically create a measure called "Number of Customer"/"Number of Customer ID" - which is a distinct count of the values in that column. Hope this helps! 

Cheryl

Customer Success