community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Count distinct clients each from from January...

Asteroid

 If I have a total of 400 unique clients in January and it grows to 800 unique clients in October, how can I get a count of how many distinct clients were added for each month?

 

Ex.

Jan - 400

Feb - 43

Mar - 61

Apr - 31

May - 55

Jun - 49

Jul - 65

Aug - 33

Sep - 30

Oct - 33

 

800 total

 

My data set starts in January and I will add to it at the end of each month.    It is a list of services and dates, so a client can have multiple services in different months.

 

Thank you!!

Alteryx Certified Partner
Alteryx Certified Partner
Step 1: SORT data by ID, Date ( note date and not month)
Step 2: UNIQUE data by ID.
Step 3: Take Unique values through SUMMARIZE by MONTH

that’s the answer.

Cheers,
Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Asteroid

Genius!  Not sure how I deciphered your answer (being a relative noob), but I did and it worked!

 

Thank you so much.

Alteryx Certified Partner
Alteryx Certified Partner
Congrats 🎊 your ready to start some weekly challenges and really start to accelerate your abilities.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels