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

Rolling 12 month distinct count

jboyle
7 - Meteor

Hi 

 

I trying to create a data set which is distinct count of customers over a rolling 12 month period, which increments by a month but don't really know where to start so any help would be greatly appreciated.  What my desired output would look something like the table below.  Have attached a example input data set 

 

Start Periodend perioddistinct count
May 2018Apr 201933
Jun 2018May 201931
Jul 2018Jun 201932
3 REPLIES 3
Aaron_Harter
11 - Bolide

@jboyle  one approach to solving this problem might involve summarize tools to perform the customer counts, and the generate rows tool with DateTime functions to create the data points required for your analysis:

1.PNG

CharlieS
17 - Castor
17 - Castor

Hi @jboyle 

 

Thanks for that example, it was really helpful.

 

I've attached an example solution. Check it out and let me know what you think. 

 

20200317-Rolling12Unique.PNG

jboyle
7 - Meteor

Thanks guys both of these solutions worked 🙂 

Labels