How to Display a Percentage instead of a Total

mehenderson · a week 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?

Huynh Loc · a week 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.