I have a table of emergency response records and I am hoping to find Unit Hour Utilization rates based off of predefined filtered time frames or temporal time frames.
Can Insights see that I have chosen a date range and then use the amount of time (let's say days) within that range in a formula to calculate the utilization rate?
Included image may better explain what my team is after.
Thank you!
I think your solution would work if my table had 1 record per day, but my table has multiple records per day.
I am aiming to extract the number of days within the filtered date range, so I think I need something like the DateDiff function for the filter?
@Aurora -
For your workflow, could you first find the average for each day using the Summary Table and then find the average of the result dataset?
If I'm understanding your use case, this would then give you the appropriate utilization rate based on whatever time range you select.