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

[abhayneilam]

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]

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]

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.

[abhayneilam]

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 .