No worries. I've done something like this before. I'll walk you through what I did with screenshots below and attached is 2018.3 workbook. If this answers your question, please mark as correct. Thx ! Don
First thing I did was to create a calculation that would tell me whether the number of days in between trued up to being 30 days or less; essentially a True/False statement and dropped that onto Rows to show next to number of days whether number of days falls into the True or False bucket.
Next I created another calculation, to identify whether the Medical Records was a single admission or a readmission with the following calc, which essentially says, if the first row then classify it as 0 and if 0 then classify it as an Initial Admit, which covers both scenarios of when a patient really only has a single event and if the patient has multiple events declares the first one as an initial admit (covers both scenarios). The ELSEIF then declares if the number of days is greater than 0, classify that event as a readmit.
I then created a second worksheet, which brings in both of those calculations to the Filters Card and appropriately filters only for those READMITS that are 30 Days or Less. Brought in your Admit Date and set it to Year & Month on Rows. Then did a count of Admit Date. Brought in another instance of Count of Admit Date and did a Quick Calculation as % of Total and set it to subtotal on each month.
Hospital Admits-Readmits.twbx 101.2 KB