Hello all,
This is my first time posting here! It is also my first time using Alteryx with my new role.
Here is some background information on the data I am trying to get: I am trying to generate a report of 'Occupied' or 'Available' hospital beds based off of the 'Bed ID' and the date (each day).
Based off of my screenshot, I generated 'Occupied' column based off of the date duration between 'Admit Date' and 'Discharge' date. It created a new row for each date in between those dates which means those beds are occupied on those dates.
I am not sure if this is the right way to approach it. It might be easier to have each day whether available or not listed as their own row... and then one column that says bed status: occupied or available for each row.
Just not sure how I to apply the logic formula to produce that.
Occupied = All days on and between Admit Date and Discharge Date
Available = Every day that does not exist on or between Admit Date and Discharge Date, or the dates between the last Discharge Date and the new Admit Date.
Also want to point out that i am focusing on date/days only, and not the hours/times.
Any help is appreciated.
