How to find % SLA for last month using a formula indicator

ThaiP
Tera Contributor

Hi, I'm trying to use a formula indicator to find % SLA for last month based on the % SLA Met. However, I do not know what indicators to use in the formula indicator.

5 REPLIES 5

GlideFather
Tera Patron

Hi @ThaiP,

do you mean SLA in general for all records (e.g. incidents, RITMs,), or for one particular record (e.g. INC0001, RITM0002), can you please provide more details?

Your question is not entirely clear, then we can try to find solutions

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */


Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @ThaiP 

 

Check this OOTB indicator and build your own

 

DrAtulGLNG_0-1751286028707.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]

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

Mark Manders
Mega Patron

Why are you trying with formula indicators? It should be 'all SLAs met / all SLAs', but a simple report would do the trick as well and even visualizes it (give it red/green colors and you show exactly what people want to see).

 

You can easily achieve that by querying to all SLAs completed on last month and to a group by on 'has breached' in a donut/pie/semi donut. Make 'false' green and 'true' red and you have everything: visualization of last month's performance and with adding data labels you have numbers/percentages. Just make sure you only take the completed ones and not the cancelled ones.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Is there a way to represent that information in a single score visualization?