30 day readmission

Hi,

I want to capture patients who have been readmitted within 30 days of their last discharge.

I have attached example dataset, however, each patient could have 3 rows of interaction of 50. I've tried using the multi-row formula tool, but I can't count back a static amount of rows.

Excel contains example data, the last two columns are the out put I'd like to create.

Help much appreciated.

30dayexample.xlsx

Workflow

Date Time

Expression

Accepted answers

Ladarthure

Hi @NPIV,

here is a draft solution I made, I first filtered to exclude all non admission and discharge, then calculated the difference in days between all the lines, and finally did a formula based on that.

Another solution would be to shift the data and have one column for admission, one for discharge, and then calculate the date difference between the previous row discharge and actual row admission.

admission.yxmd

All comments

Ladarthure

Hi @NPIV,

here is a draft solution I made, I first filtered to exclude all non admission and discharge, then calculated the difference in days between all the lines, and finally did a formula based on that.

Another solution would be to shift the data and have one column for admission, one for discharge, and then calculate the date difference between the previous row discharge and actual row admission.

admission.yxmd

afv2688

Hello @NPIV ,

I came up with this solution:

Let me know if it works for you.

Regards

30 days.yxmd

NPIV

Thank you! Was almost perfect, just had to add a group by client id to the multi-row tool.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703