How to show Unique Incidents List on the Response SLA Reports

[sk59]

Hi All,

We are running a report on 'incident_sla' table which displays the list of incidents with response sla's attached.

When there are multiple responses attached to a specific incident it showing 2 records of the same incident which is causing an issue to track the number of incidents.

I am using count distinct on a Pie report. When I mouse over on the Pie diagram it shows the count correct. But If click and see the list it again shows the full list of incident including duplicate incident records.

How to show only distinct incident records. Please help.

[Slawek_Radziewi]

It is the list so rather not possible to hide it. You can try to group by number. You can also try to filter out some SLAs from list.

[Adam Stout]

If you think you have duplicates, then you need to look at your SLA definitions.  It sounds like you are expecting a reset instead of new SLA to be triggered.

[RoqueFolminar]

Have you found any solutions to this @sk59 ?

Thank you