How to calculate average of time

Vasanth Pandia1 · ‎02-23-2018

Hi All,

I have a requirement to calculate "Average time spent for a request from when the record was created until the request is accepted or rejected".

Please let me know how to calculate the average time, I need to use this in Performance Analytics.

Regards,

Vasanth

Dennis R · ‎03-04-2018

Vasanth, this is exactly what metrics is for. You need to configure a metric on the request table for field duration on the state field, and then you can configure an indicator in PA to collect the durations of those metrics, doing whatever calculations you want on them. (For an average, you'd divide the sum of all of the times collected by the number of records collected.)

You have to understand that PA by itself can't go back in time to figure out when something happened if the timestamps of those events aren't recorded; it can only do calculations based on the current state of records as of the time the collector runs. If you want historical data, you have to record that data in some way, which means you're going to have to either record a timestamp on the records themselves or use metrics to collect the data that can be rolled up in PA.

View solution in original post

Prabhu6 · ‎02-08-2023

Vasanth, Have you got the solution, May i know the formula for Average calculation?