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

Summing number of active records over time without history

csh8428
11 - Bolide

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_IDStart DateTerm DateStatus
A1/5/2019 Active
B1/12/20192/9/2019Termed
C1/19/20192/9/2019Termed
D1/26/20192/9/2019Termed
E1/26/2019 Active
F2/2/2019 Active
G2/2/2019 Active
H2/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 DateThis many Users were Active
1/5/20191
1/12/20192
1/19/20193
1/26/20195
2/2/20197
2/9/20194
2/16/20195

 

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

2 REPLIES 2
markcurry
12 - Quasar

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

 

Active Users.PNG

csh8428
11 - Bolide

Perfect!

 

Thanks!!

Labels