Month Wise Incident Counts (Table View)

[chinthaka]

I want to generate a report containing monthly counts of incidents handled by a set of assignment groups. (Please refer to the attachment)

Tried to generate this using pivot table option in reporting module, but month wise breakdown is not appearing.  Any suggestions to achieve this.

[Arav]

Hi,

You can create a time series report (e.g Column report) and add Trend by as "Created" per "Month" and add "Assignment Group" as Group by.

Note that if you run the report on incident table, it will only give show incidents handled by the last assignment group. To understand the number of incidents handled by a group even though it may have been transferred to another group, explore incident_metric.

Thanks,

Arav

[chinthaka]

Thanks Arav, but my requirement is to have a tabular view as per the attachment.

[D N]

Did you ever figure this out? I have a very similar requirement.

[Akash_Yadav]

Even i do have similar requirement. Please let me know if you have figured this out.