Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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
14 - Magnetar
14 - Magnetar

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