Reports and dashboard

spectura77
Tera Contributor

‎09-06-2024 09:56 AM

How can we create a create a report in service now for  successful, failed and completed vs open changes and average time to close metrics is there way possible

i have tried to create a report but it is not showing the avg time from change_request table.

Please guide.

0 Helpfuls
  • 980 Views
2 REPLIES 2

AndersBGS
Tera Patron

‎09-06-2024 12:44 PM

Hi @spectura77 ,

 

 what is it that you would like to utilize average time to close till? how would you calculate this? In general it make sense from incident perspective, and it partially makes sense from a request perspective… but not from a change perspective.

 

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

 

Best regards

 Anders

0 Helpfuls

Dr Atul - LNG
Tera Patron

‎09-07-2024 12:54 AM

Hi @spectura77 

 

Change involves many states, and every state takes time. The best is to use PA to get this.

https://INSTANCENMAE.service-now.com/now/nav/ui/classic/params/target/%24pa_scorecards.do

AGLearnNGrow_0-1725695669881.png

 

 

 

 

https://INSTANCENMAE.service-now.com/now/nav/ui/classic/params/target/%24pa_dashboard.do%3Fsysparm_dashboard%3D05b0a8b7c3123010a282a539e540dd69

0 Helpfuls