how do we get average approval time for individual approvals?

[Ravish Shetty]

hi all,

We want to see the average time it takes to provide any approval for some requests. I see that we can leverage the 'approval set' attribute on task records but for requests which have multi-level approvals, this may not be enough as it gives an aggregate information.

Thanks,

Ravish

[john_duchock]

have you tried setting up a metric on the approval table (sysapproval_approver)?

https://docs.servicenow.com/bundle/newyork-platform-administration/page/use/reporting/concept/c_Metr...

[Ravish Shetty]

we dont have a metric defined for this use case. would this also work for historical data?

[Slawek_Radziewi]

You can calculate time in scripted indicator for times between created and approved (approval time or set on sc_req_item table). 

After that average that time. 

If you want separate approvals time you will have to use sysapproval_approver table.