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 !!
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.
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.
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 .