I have a dashboard that shows the calendar view of an individual. One of the metrics on the dashboard is the total duration of all the meetings that the individual has had based on the time filter picked. I would like to create a calculation that shows "Utilization rate".. i.e., the total amount of time the individual is in meetings divided by the total available time based on the user filter.
I am not sure how to calculate the total available time based on the user filter. Any thoughts on this?
Thanks in advance.
Could you please share some sample mock up data in packaged workbook?