How to calculate the approval Duration?

[Ruchi19]

I want to calculate how long did it take for an approval to approve the request?
Based on that field, we need to do reporting. please help how to calculate the duration?

[Chuck Tomasi]

The start time would be the date the request was created. The approval time would be the last date it was updated once it has been approved. With that, you should be able to build a fairly simple report with:

Type: List
Table: Approval [sysapproval_approver]

Filter:
State | is one of | Approved, Rejected, Cancelled

[terrenz_tan]

ctomasi

[terrenz_tan]

hi, thank you for the solution, I had tried using below criteria, but I didn't get the duration I wanted. I want to measure Request Item approval Duration. this table seems to measure Including Incident and Change Request. I had tried to create a new custom table and want to user the table sysapproval_approver as an extended table, But I could not find it on the extends base table list. Anyone please?
Type: List
Table: Approval [sysapproval_approver]

Filter:
State | is one of | Approved, Rejected, Cancelled

[Ruchi19]

I created below steps to calculate approval duration.
1). new metric definition on sysapproval_approver table
2). new business rule - metrics events (sysapproval_approver) on approver table

once these two are created , if you go back and submit any service request ticket, you will see it being captured at the bottom of metric definition.