Set y axis on line chart to percentage

donipayne
Giga Contributor

Is there any way to set the y axis of a line graph to be a percentage.   We want to report on percentage of SLAs met over time. We can get a count, but not a percentage.

1 ACCEPTED SOLUTION

Aditya Telideva
ServiceNow Employee
ServiceNow Employee

Hi Doni,


You can


create an automated indicator on the incident_sla table counting all SLAs for the time period. Next, create an automated indicator on the incident_sla table counting the number of SLAs that were breached for the time period.   Finally, create a formula SLA that's something like:


[[1 - ( Breached Help Desk SLAs / Total Help Desk SLAs ) * 100 ]]



That will give you your first requirement, the % of met response SLAs.


Let me know if this helps,


Aditya Telidevara


View solution in original post

1 REPLY 1

Aditya Telideva
ServiceNow Employee
ServiceNow Employee

Hi Doni,


You can


create an automated indicator on the incident_sla table counting all SLAs for the time period. Next, create an automated indicator on the incident_sla table counting the number of SLAs that were breached for the time period.   Finally, create a formula SLA that's something like:


[[1 - ( Breached Help Desk SLAs / Total Help Desk SLAs ) * 100 ]]



That will give you your first requirement, the % of met response SLAs.


Let me know if this helps,


Aditya Telidevara