Dashboards & Visualizations

How to get data to appear on a graph after adding the "%" character to numeric results?

abhayneilam
Contributor

Hi,

I have a search which is showing the percentage of success and failure, but when I am adding "%" sign along with the numbers, I am not able to see the graph as this becomes a string.

| eval Field_one=round((Failure/Total)*100,2)." %" | eval Field_two=round((Success/Total)*100,2). " %" | .....

Now that "%" is added to both fields, it is causing the graph to not be shown and there is no data displayed for these two fields. When I remove "%" I am able to see the data on the graph.

My requirement is to see the numbers with % sign in the dashboard.

Please help !!

somesoni2
Revered Legend

Graphs shows only the numerical values. Once you add "%" to the values, it becomes a string. workaround could be to put an indicator in the legends (field names) OR axis titles to denote that graph shows percentage.

gfuente
Motivator

Instead of eval, try fieldformat,

http://docs.splunk.com/Documentation/Splunk/6.2.1/SearchReference/Fieldformat

eval changes the fieldtype from numeric to string. fieldformat changes the visual representation, but the underlying value remains numeric.

0 Karma

abhayneilam
Contributor

I have used fieldformat Field_One=tostring(Field_One) + "%" also but again in the number it is showing % but in the visualization it is not showing the graph .

0 Karma
Get Updates on the Splunk Community!

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...