How to create a report on SLA breaches where it only shows each incident one time.

Patrick Cavanau
Tera Contributor

Currently I am trying to show all incidents and have it grouped by SLA has breached. The issue with that is that it shows multiple SLAs for the same incident and the requirement for this task is that it shows each incident only one time and if it has breached any of its SLAs. Currently I am showing the data using the incident SLA table and grouping it by has breached. When I switch to just the incident table, it does not show the option to group by "has breached" anymore. I was thinking maybe platform analytics may have a way to achieve this ask.

Thank you for any help

8 REPLIES 8

AndersBGS
Tera Patron
Tera Patron

Hi @Patrick Cavanau ,

 

No, performance analytics is not the best solution for your query in my opinion. Instead you need to verify what you actually would like to see and the narrow in your condition on the report you're creating. E.g. if there is several SLAs is attached for the same incident:

 

Ensure grouping by number

AndersBGS_0-1694431389808.png

And condition "has breached is true":

AndersBGS_1-1694431433233.png

This will give the result:

AndersBGS_2-1694431459132.png

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders 

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Thank you for the response @AndersBGS. We are grouping by has breached in the incident SLA table and they want it to show only each incident once. This is where we are running into an issue, as this could show each incident multiple times. I am not sure if there is a way to filter it to only show each incident once if the incident has breached any of its SLAs 

 

PatrickCavanau_0-1694435819837.png

 

Hi @Patrick Cavanau ,

 

Have you tried the aggregation "count distinct"?

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

This helped a lot thank you. The last issue we are running into is that it still counts the incident twice if one of the incidents has breached and one has not. As an example, in august there were 35 incidents. This chart shows that there were 35 that did not breach SLA and 1 that did, totaling to 36. The reason for this was one incident has an SLA that breached and one SLA that did not, so it was counted two times. Is there any way to fix this using filtering? Thank you

PatrickCavanau_0-1694540567340.png