How to Display a Percentage instead of a Total

mehenderson
Mega Contributor

a month ago

I built a Visualization Dashboard with several Single Score visualizations, each with their own filters. I'm being asked if I can have the visualizations show the percentage instead of the single score.

For example: If my total network device count is 17,906 and the count of my network devices where the location field is empty is 189 the visualization below would show 1.06%. How would I achieve this? 

mehenderson_0-1776871075025.png

 

0 Helpfuls
  • 423 Views
1 REPLY 1

Huynh Loc
Mega Sage

a month ago

Hi @mehenderson ,

To display a percentage, you’ll need to use Performance Analytics with a Formula Indicator.
Create two automated indicators (one for total devices and one for devices with an empty location), then combine them in a formula indicator using (numerator / denominator) * 100.
Use that formula indicator in your Single Score visualization—this is the supported and OOB method for percentage KPIs in ServiceNow.
https://www.youtube.com/watch?v=u1k0kplZlZY

If this response was helpful, please consider marking it as Correct and Helpful. You may mark more than one reply as an accepted solution.

 




0 Helpfuls