To calculate the running utilization rate, you can follow these high-level steps:
First, create a calculated field to determine the total time worked. You can do this by subtracting the starting time from the ending time.
Next, create another calculated field to determine the available time. You can do this by multiplying the total hours in a day by the number of days.
Now, create a calculated field to determine the utilization rate. You can do this by dividing the total time worked by the available time and multiplying by 100 to get a percentage.
To display the running utilization rate, you can create a table or chart in your Amazon QuickSight dashboard. Add the ‘Date’ field to the X-axis, the ‘Utilization Rate’ field to the Y-axis, and apply the ‘RunningSum’ function to the ‘Utilization Rate’ field.
By following these steps, you should be able to calculate and display the running utilization rate in your Amazon QuickSight dashboard.
Also, please use these resources from DemoCentral to help you frame the context:
Level Aware Calculations
Cohort Analysis - Customer Retention
If you have any further questions or need additional assistance, please feel free to ask.