Reports showing total number of incidents closed, no of incidents met SLA and SLA met %

Padmaja_28
Tera Contributor

Hi team,

We have a requirement for preparing servicenow dashboard showing data related to SLA of incidents in a weekly manner.

The sample of the required output is as attached. Can you please help me in achieving it as it has to be built on incident and incident sla and task sla tables.MicrosoftTeams-image (1).png

Help me know the feasibility for achieving this.

2 REPLIES 2

AndersBGS
Tera Patron
Tera Patron

Hi @Padmaja_28 ,

 

  1. The visualization cannot be achieved, if it should look like the Excel report
  2. # of tickets closed can be done through report designer, performance analytics or analytics workspace
  3. # of ticket met SLA can be done through report designer, performance analytics or analytics workspace
  4. Met SLA % can be done through performance analytics
  5. Service level met - what is this?

So basic, to have it all, you need performance analytics to do the percentage calculation.

 

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/

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Padmaja_28 

 

@AndersBGS is guru in reporting so I am not going outside that boundary. I tried a bit in reports, this can be achieved

LearnNGrowAtul_0-1708078998477.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]

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