We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. 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