1 Reply Latest reply on Oct 19, 2018 2:50 PM by Mahfooj Khan

    Calculate hours based on user filter

    Sunder Gopinath

      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.