Assignment group interactive filter, for the SLA Breakdown by Assignment Group table

[CMH]

Hi Everyone,

I have a report, that shows results of the "sla_breakdown_by_assignment" table. It shows all the groups that touched the incident and consumed time in the sla task. It is handy for seeing who consumed the most business elapsed time, contributing the most to the breach of the SLA.

So when I make the report, it of course shows multiple groups, sometimes 20+ of them, so I wanted to make an interactive filter in my dashboard, that lists all the assignment groups involved, to allow the viewer of the report to filter for their group only. (So if a group never consumed any of the SLA

Trouble is, when making the interactive filter (which I point at the sla_breakdown_by_assignment table), it says I can chose the SLA definition.... but I cannot find a way to instead show a list of the assignment groups listed in this table.

When I use AI to search for a solution, the solutions proposed talk about dotwalking to the task_sla table to see what group is assigned to the task, but this is not good, because it only thinks about the group that is CURRENTLY assigned to the incident... whereas the point of the sla breakdown report is to show a list of all the groups that had the ticket\sla over time.

So I guess that I am trying to say, I am trying to make a filter, that will look to the sla_breakdown_by_assignment table, and offer me a list of the assignment groups captured in that table (not the list of groups from some other table)..

Would be great if someone can give me a hint,

Many thanks All

[Mark Manders]

Are you creating legacy dashboard/filters or are you already on Platform Analytics? Because I just tried on Platform Analytics and was able to point my group filter to the sla breakdown by assignment table and select the 'assignment group' field.