How do I create a report on Mean Time to Approve a Request for a Specific Item type?

[David Diaz]

We only have OOB Reporting available in Service Now (Jakarta), I would like like to create a report on the following:

• Mean Time to Approve a Request for a Specific Item type

I have checked other posts but none seem to have the answers I need. I am just thinking of using a counter but can't figure out which table to use and what are the filter conditions?

Below are the other post that I have already checked:

https://community.servicenow.com/community?id=community_question&sys_id=bc0247e9db98dbc01dcaf3231f96...
https://community.servicenow.com/community?id=community_question&sys_id=6d58cfaddb1cdbc01dcaf3231f96...
https://community.servicenow.com/community?id=community_question&sys_id=d5cf6f74dbd1dfc42328f3231f96...

[Slawek_Radziewi · Accepted solution]

Chuck Tomasi answered this already.

You need to use Table: Approval [sysapproval_approver]

Then you have too approaches:

1. Performance Analytics - create indicator with time calculation between creation and approval times.

2. Reporting - create Business rule to save duration when approved to a field in table (custom field). After that report on that field with duration calculated.

Condition for Request will be