Want to make a report that is having only the unique incidents from the Task SLA

Night
Tera Expert

Need help on it.
As you can see there are multiple INC for the same, which will make the report a mess when I have to show a total number of different incidents that has breached the SLA.
Is there a way to solve it? like having only unique selected.

Night_0-1689592793232.png

 

1 ACCEPTED SOLUTION

Ahmmed Ali
Mega Sage

Hello @Night 

 

If your requirement is to show all the incidents which have at least one breached SLA, the you can create report directly on the incident table instead of incident_sla or task_sla as shown below:

 

AhmmedAli_0-1689597735956.png

 

You can set additional condition such as incident creation date/assignment group in above filter as usual.

 

Thank you,

Ali

 

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali

View solution in original post

4 REPLIES 4

Ahmmed Ali
Mega Sage

Hello @Night 

 

If your requirement is to show all the incidents which have at least one breached SLA, the you can create report directly on the incident table instead of incident_sla or task_sla as shown below:

 

AhmmedAli_0-1689597735956.png

 

You can set additional condition such as incident creation date/assignment group in above filter as usual.

 

Thank you,

Ali

 

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali

Hi @Ahmmed Ali,
Thanks for the solution it worked as I wanted it to work.

AndersBGS
Tera Patron
Tera Patron

Hi @Night ,

 

I would recommend you to utilize the conditions: stage is completed AND breach is true.  Y utilizing this, you should only have one SLA for each incident. If several SLA still occurs, then you need to add in a filter for the sla definition is ….

 

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/

Hi @AndersBGS,

Thank you for giving me a helping hand for the question I asked, But the solution do not work to show different incident. 
Regards
Night