Report on Incidents that captures breached incidents in respective group and also closed in last month

[Srinivas K]

Hi All,

We need to create a  report on incidents which are breached on previous month for resolution sla and also closed on the same month. We also need to fetch in which assignment group, the incident got breached.

As of now, I have created a report on sla_breakdown_by_assignment table where I am able to fetch incidents breached on previous month along with the assignment group in which it got breached

But there is no closed field on the sla_breakdown_by_assignment table, hence I am unable to fetch closed field , so that I can also get incident which are closed in last month.

Can anyone help me what are the next steps to be taken to fulfill this.

Table: sla_breakdown_by_assignment

[Majji Koteswara · Accepted solution]

Hi Srinivas,

For your report, you can add one more column and filter condition as shown below.

Hope it works. Also I don't understand your second filter condition.

Also you can try to follow below snapshots to achieve the same.

Finally Run the report then you will get the desired data.

Regards,

Majji Koteswara Rao