How do I show an SLA achieved percentage of the overall tasks against that SLA?

MattA1
Tera Contributor

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:

 

MattA1_0-1665501444231.png

 

 

The widget is set up as follows:

 

MattA1_1-1665501542858.png

 

 

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!

1 REPLY 1

Hasan6
ServiceNow Employee
ServiceNow Employee

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:

Hasan6_0-1701049241311.png

 

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:

Hasan6_1-1701049905017.png

 

Hope this helps

Best

Hasan