How to report on the same threshold for different SLAs.

dbenjile
Kilo Contributor

Good afternoon experts,

I am attempting to generate a report which captures all SLAs which have passed the "80%" threshold mark.

When dealing with Incidents, these are the measurable SLAs:

        -           Incident Response

        -           Incident Resolution

And if you breakdown Incident Resolution by Priority, you have the following:

        -         Resolution Priority 1 (4 Hours)

        -         Resolution Priority 2 (1 Business Day or 10 hours & 30 minutes)

        -         Resolution Priority 3 (3 Business Days or 31 hours & 30 minutes)

        -         Resolution Priority 4 (5 Business Days or 52 hours & 30 minutes)

What metrics/filters should I be using in order to capture any incident that has passed the 80% threshold for all resolution SLAs?

find_real_file.png

The image above allows me to filter based on a static given metric. However, I need to identify a method/rule/metric which is dynamic and differentiates between 80% of 4 hours or 80% of 5 business days and capturing them both respectively.

Is there a metric? or a Data table I should be referencing?

Thankyou all.

1 ACCEPTED SOLUTION

martijnfieten
Tera Contributor

Hi David,



You have to collect scores from the incident_sla table. Then add the following condition:


Schermafbeelding 2016-01-12 om 09.30.35.png


This is the short version of the answer. If you have additional questions, let me know!



Martijn


View solution in original post

2 REPLIES 2

martijnfieten
Tera Contributor

Hi David,



You have to collect scores from the incident_sla table. Then add the following condition:


Schermafbeelding 2016-01-12 om 09.30.35.png


This is the short version of the answer. If you have additional questions, let me know!



Martijn


Hey Martijn,



Yup that's definitely the answer.


How embarrassing, I completely overlooked that..



Thankyou.