Alteryx Auto Insights is currently available in the United States, United Kingdom, Australia, and Singapore (English only). Check back here for updates as this availability and language support continues to expand.

Alteryx Auto Insights Discussions

Find answers, ask questions, and share expertise about Alteryx Auto Insights
Get started with

Alteryx Auto Insights

Lesson 1

Introduction to Alteryx Auto Insights

Lesson 2

Understanding Data with Alteryx Auto Insights

SOLVED

Count Distinct

cgoodman3
13 - Pulsar
13 - Pulsar

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.

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
1 REPLY 1
cherylcarrie
Alteryx
Alteryx

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