Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

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 

1 ACCEPTED SOLUTION

Yes :). It'll give you better control as you can then be more granular in defining what is and isn't included in your MTTR KPI, without needing to manage a lengthy script. The logic is managed within each SLA resolution definition 

View solution in original post

6 REPLIES 6

so then shall i use this formula in task_sla table MTTR = ([MTTR - SLA Business Time (Sum)] / 3600000) / [MTTR - Count of Completed Resolution SLAs] give ur suggesstion

Yes :). It'll give you better control as you can then be more granular in defining what is and isn't included in your MTTR KPI, without needing to manage a lengthy script. The logic is managed within each SLA resolution definition