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
