Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

approval time taken for ritm wit multiple approval

mohitsingh
Tera Contributor

‎03-17-2026 03:49 AM

Dear All,

 

I have 2 layer of approval for a request, 1st line manager and second one is with set of people.

I want to showcase time taken by each approver for a request.

Can anyone suggest me how to calculate without customization?

0 Helpfuls
  • 434 Views
3 REPLIES 3

maliksneha9
Mega Sage

‎03-17-2026 04:00 AM

Use the Approval [sysapproval_approver] table

Every approval (manager + group approvals) creates records in: sysapproval_approver

 

This table already stores:

  • Created → when approval was sent

  • Updated → when it was approved/rejected

  • Approver → user

  • State → approved/rejected

  • Approval for → your RITM / request

Calculate time taken:-

 

Time taken = Updated - Created

  • Created = Approval assigned time

  • Updated = Approval action time

This gives exact approval duration per approver

0 Helpfuls

mohitsingh
Tera Contributor
In response to maliksneha9

‎03-17-2026 04:14 AM

Hi, i am looking for solution with out customization, means weather is it possible via indicator?

we did a check on metric and when there is multiple approval the segregation is not looks possible as it is capturing time for all approvers 

0 Helpfuls