Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Count distinct clients each from from January...

paulb1
8 - 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!!

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus
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 restart. Order shall return.
Please Subscribe to my youTube channel.
paulb1
8 - Asteroid

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

 

Thank you so much.

MarqueeCrew
20 - Arcturus
20 - Arcturus
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 restart. Order shall return.
Please Subscribe to my youTube channel.
Labels