3 Admits within 12 Months?

Experts -

Here's the scenario: I have member ids and admit dates. The admit dates may be in 2019, 2020 or both, and can be 1 or more per member. I need to figure out which members had at least 3 admits within 12 months.

Your help in solving this problem is greatly appreciated!

Datasets

Developer

Accepted answers

apathetichell

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/COUNTIFS-Dynamic-conditions/td-p/752610

@danilang's workflow can be adjusted for your need. The condition on the mutli-row count is modified to make sure that the previous admits occurred within 12 months. The most straight forward way to do this would be expand the multi-row option 2 and check if datetimediff([date],[row-2:date],"years")<=1 and increment the count if is or reset the count if it isn't.

All comments

apathetichell

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/COUNTIFS-Dynamic-conditions/td-p/752610

Bonediggler

That's a start I think, I will try it out.

But what is multi-row "option 2"?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703