I'm somewhat new to Alteryx(little over a year). I have a problem where I have to count the number active users over a period of time, but I don't have a history table. I just have a snapshot of their current status and the date they were terminated if they were terminated.
The data-set has a min start date and term date of 01/05/1900(a Friday), and each start and term date will also be a Friday. There is no max start or term date.
Data looks like this, since it's what is current as of today.
User_ID | Start Date | Term Date | Status |
A | 1/5/2019 | Active | |
B | 1/12/2019 | 2/9/2019 | Termed |
C | 1/19/2019 | 2/9/2019 | Termed |
D | 1/26/2019 | 2/9/2019 | Termed |
E | 1/26/2019 | Active | |
F | 2/2/2019 | Active | |
G | 2/2/2019 | Active | |
H | 2/16/2019 | Active |
I want to get it to look like this(Trying to count the number of active users during every 7 day interval starting at 01/05/1900, where [As of This Date] should increment every 7 days as the workflow is run in the future)
"As of This Date" should start at 01/05/1900 and go up by 7 days each increment
As of This Date | This many Users were Active |
1/5/2019 | 1 |
1/12/2019 | 2 |
1/19/2019 | 3 |
1/26/2019 | 5 |
2/2/2019 | 7 |
2/9/2019 | 4 |
2/16/2019 | 5 |
I've tried laying with various breakouts, summarize, and generate rows, but can't seem to get it quite right.
I've attached a sample input file.
Thanks for any help!
Craig
Thanks for any help
Solved! Go to Solution.
Perfect!
Thanks!!