11 Replies Latest reply: Sep 15, 2016 3:58 AM by Apoorva Dhulehole RSS

    How to calculate average over a range of data?

    Apoorva Dhulehole

      Hello,

       

      I have a requirement where in i need to create a line graph which shows the average usage of licenses per day. Now the problem is, i have a "Time" field which has data for every 15 mins. This "Time" has data for entire day (i.e. from early morning 12 AM to midnight 11:59 PM). Now i need to calculate the average for only working hours say, from 8 AM to 8 PM per day.

       

      If i calculate average for the entire day considering the Time from morning till evening, it would depict a wrong average, as the licenses will not be utilized for half of the day. So how can i pick up just that Time for a day and calculate the average license utilization over a day?

       

      Any idea?

       

      Thank you.