Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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/