Monthly Average of Incidents assigned to an assignment group

SBurns186
Kilo Contributor

Hello,

 

I am looking to build a report, that is looking for the average number of active incidents that were assigned to a specific grouping of assignment groups each month. Trying to get an understanding of our ticket load per month,

 

Thanks in advance,

 

Sean

2 REPLIES 2

Tsura Andreeva
Mega Sage

Simple suggestion would be to create a Column Report and use the Trend by Created by Month and add group by Assignment Group

AndersBGS
Tera Patron
Tera Patron

Hi @SBurns186 ,

 

to capture the assigned to specific assignment group during a month, you need to utilize incident metric for assignment group. based on this, you can afterwards create your report based on the incident_metric table.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/