https://community.splunk.com/t5/Splunk-Search/Insert-quot-quot-symbol-to-a-number-without-converting-it-to/m-p/324836#M96878 <P>Hi,</P> <P>Is it possible to add a "%" character/symbol to a number without converting it to a string?</P> <P>I tried to use this code:<BR /> <CODE>| eval percentage = round((On_time/Total)*100)."%"</CODE></P> <P>But it converted the number into a string, so when I try to use the "percentage" field as an overlay in a Column Chart, it does not show anything. It has to be an integer. <BR /> I want it to have the "%" character so that when I hover over the overlay, the value would have the "%" sign so that it would be easy to know that it is a percentage, not just any number.</P> <P>Is this possible?</P> <P>I hope anyone can help me with this.</P> <P>Thank you.</P> Fri, 08 Dec 2017 07:55:25 GMT jvmerilla 2017-12-08T07:55:25Z https://community.splunk.com/t5/Splunk-Search/Insert-quot-quot-symbol-to-a-number-without-converting-it-to/m-p/324836#M96878 <P>Hi,</P> <P>Is it possible to add a "%" character/symbol to a number without converting it to a string?</P> <P>I tried to use this code:<BR /> <CODE>| eval percentage = round((On_time/Total)*100)."%"</CODE></P> <P>But it converted the number into a string, so when I try to use the "percentage" field as an overlay in a Column Chart, it does not show anything. It has to be an integer. <BR /> I want it to have the "%" character so that when I hover over the overlay, the value would have the "%" sign so that it would be easy to know that it is a percentage, not just any number.</P> <P>Is this possible?</P> <P>I hope anyone can help me with this.</P> <P>Thank you.</P> Fri, 08 Dec 2017 07:55:25 GMT https://community.splunk.com/t5/Splunk-Search/Insert-quot-quot-symbol-to-a-number-without-converting-it-to/m-p/324836#M96878 jvmerilla 2017-12-08T07:55:25Z https://community.splunk.com/t5/Splunk-Search/Insert-quot-quot-symbol-to-a-number-without-converting-it-to/m-p/324837#M96879 <P>By definition, a field with anything other than digits or '.' is a string. There is no way around that.<BR /> If you were using a pie chart, you could use the SimpleXML charting.chart.showPercent option to display percentages, but that is not supported by other chart types.</P> Fri, 08 Dec 2017 13:59:21 GMT https://community.splunk.com/t5/Splunk-Search/Insert-quot-quot-symbol-to-a-number-without-converting-it-to/m-p/324837#M96879 richgalloway 2017-12-08T13:59:21Z