How to create a report on SLA breaches where it only shows each incident one time.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-11-2023 03:46 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-11-2023 04:24 AM
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
And condition "has breached is true":
This will give the result:
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-11-2023 05:41 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-11-2023 06:16 AM
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-12-2023 10:44 AM
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