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 Period | end period | distinct count |
May 2018 | Apr 2019 | 33 |
Jun 2018 | May 2019 | 31 |
Jul 2018 | Jun 2019 | 32 |
Solved! Go to Solution.
@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:
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.
Thanks guys both of these solutions worked 🙂