Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

MTTR calculation by excluding onhold state

Jeya priya
Tera Contributor

MTTR calculation by excluding onhold state , OOB indicator having [[Summed duration of resolved incidents]] / [[Number of resolved incidents]]  its include onhold state so how to exclude and calculate MTTR 

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

@Jeya priya 

see this link which talks about custom script, see if that helps you in calculation in your PA indicator

Create metric definition to calculate total time taken excluding on hold duration 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

i will create a metric definition by excluding the onhold state , then how to calculate MTTR, via report or you saying to create a custom field to store the value

@Jeya priya 

Please check that link and there is an approach

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Kieran Anson
Kilo Patron

Hi Jeya,

Rather than creating a new metric, have you considered using task_sla as your indicator? Assuming you have SLAs already, you can leverage the SLAs with a type of resolution to calculate the overall duration.