Summing number of active records over time without history

[csh8428]

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

[markcurry · Accepted solution]

I think this should do it for you....

 

[csh8428]

Perfect!

Thanks!!