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.

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