How do I show an SLA achieved percentage of the overall tasks against that SLA?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-11-2022 08:21 AM - edited 10-11-2022 08:22 AM
Hi! Trying to learn more about PA and I've got quite far and surprised myself but I'm now stuck.
I've created some indicators against various SLAs and I can show the overall breakdown of achieved vs breached for the SLAs I've queried against. I've used the has breached breakdown to do this and get results like below:
The widget is set up as follows:
And the indicator is looking at Closed.Task.SLA with the condition being that the SLA definition matches the SLA I am trying to show the analysis of.
However, I also want to show the percentage of this SLA which has achieved. I have all the data I need and I could use (achieved / (achieved+breached)) * 100 but I don't see any easy way of doing this despite it being seemingly straightforward.
Can anyone help me? I'm sure it can't be that hard but I'm stuck!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-26-2023 05:51 PM
Hi Matt,
Let me introduce you to Formula Indicators. Formula Indicators are indicators that use data from other indicator(s), and can optionally perform mathematical operations on them, and show the resulting score as their output.
There is no jobs/score collection needed here as it uses scores from the underlying indicator.
Search for Formula Indicators in the left nav, and click new:
In the formula field, select browse for an indicator, and select your indicator, broken down by acheived value.
Continue the formula to add the denominator as total sla records. Don't forget to multiply by 100.
Finally, your formula should look something like:
Hope this helps
Best
Hasan