Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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