How to create report to show breached incidents assignment group

[Priyanka145]

Hi All,

We Want a report to show the list of incidents that are breached under resolution sla along with the breached assignment group. I created report on sla_breakdown_by_assigment and able to fetch assignment group in which sla is breached.

But over the report we are getting the breached incidents data only from when the table is created. It means ,if sla_breakdown_by_assigment is created on May month, so it is not showing the breached incidents  before to may. But as per requirement we need those as well. As I understood the only way is via performance analytics, could you please anyone guide me over it or any other approach as I am new to this.

[Mark Manders]

Can't you just create a report on the task_sla table with conditions task.task_type = incident AND has breached = true and show the (dotwalked from task-table) assignment group on the report?

If my answer helped you in any way, please then mark it as helpful. If it resolved the issue, please mark it as correct. This way others will find it in the solved queue and helps them on similar queries.

Mark

[Priyanka145]

It is showing the latest assignment group instead of breached assignment group. Incident can either be closed or not in same breached assignment group right , so unable to fetch it

[Vishnu Prasad K]

Hi Priyanka,

The reporting solution can serve your purpose I believe, because the task_sla table will be having the entire information from the beginning, so if you create the report on this table with the correct date filter as per your need, you should get what you are asking for. Also create an interactive filter on Assignment group  and include it also in the list view

If you want to do it in PA, create an indictor source on task_sla table. Breakdown source on group table and map it to task.assignment_group in the breakdown.  Better to set the frequency as daily. Create a job to collect the historical data  and daily data. Configure the widget and set the time series as monthly if you want to see the results based on monthly basis.