report on average time taken by a team to resolve each incident which areassigned to them in a week

chaitanyakumarD
Tera Contributor

hi all

i want to create  a report on average time taken by a assignment group to resolve each incident which are assigned to them in a week   

can any one provide relevent solution for this 

6 REPLIES 6

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @chaitanyakumarD 

 

Try to create a trend reporrt

 

AGLearnNGrow_0-1710148678527.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

AndersBGS
Tera Patron
Tera Patron

Hi @chaitanyakumarD ,

 

Two different solutions. The easy on: Create a report through the report designer:

AndersBGS_0-1710150925263.png

Create a time series visualization: 

AndersBGS_1-1710150953817.png

You can either utilize the condition "assignment group is (dynamic) one of my groups" or group by assignment group - it's up to you.

 

remember to set below:

AndersBGS_2-1710151119102.png

Second option is to utilize performance analytics which require some more configuration.

 

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/

Ola30
Tera Contributor

Hi @AndersBGS  could you please advise how this could be achieved via performance analytics? Thanks

Hi @Ola30 ,

 

Basically you should have two automated indicators. One for count if tickets for the assignment group, and one for sum of resolution time. By doing this you can in a formula indicator divide the sum with count to get the average. 

 

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/