How to find % SLA for last month using a formula indicator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2025 05:10 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2025 05:18 AM
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! */
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2025 05:20 AM
Hi @ThaiP
Check this OOTB indicator and build your own
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 as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2025 05:24 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2025 05:31 AM
Is there a way to represent that information in a single score visualization?