Hello Alteryx everyone,
I'm working through Mobile Crisis Visits. These consist of 3 date fields: the Mobile Crisis Dispatch Screening (the date the crisis call came in), the Mobile Crisis Encounter date (the date the staff went to the client and provided services) and the Mobile Crisis Follow Up (the dates after the Encounter when regular services occurred).
So, I'm trying to figure out the days between the Screening Date and the first encounter date following the screening date. But, there are some considerations:
-There may be multiple screening dates for 1 encounter date, and I need to calculate the days between each screening date to encounter date
-There may be no encounter dates for each screening date.
-The minimum days between the encounter date and the first follow up date following the encounter date.
-But, there may be no follow up dates.
My brain has broken trying to figure this out! So, a Pre-Thank you for your assistance. See the attachment for where I'm at.
