Incident Count Reporting

[NC7]

I am trying to create a report for the count of incidents an assignment group had at a specific time in the past. For example, if I wanted to know what the count of tickets in the Desktop Team had at 7 AM for the last 5 Mondays. Has anyone had experience with this?

[Dr Atul G- LNG · Accepted solution]

Hi @NC7 

We can’t fully automate this report, but it can be done somewhat like this.

Report type: Trend

Select the Monday's manually.

[Brian Lancaster]

You can try using the incident_metic table. There is a metric that tracks when the assignment group changes. So It will have historical information where doing it on the incident table only has what group it is assigned to currently. Example screenshot below just replace where I have Service Desk with you Desktop Team.