https://community.splunk.com/t5/Splunk-Search/How-to-convert-decimal-numbers-to-percentage/m-p/297241#M89679 <P>Hi guys,</P> <P>With my below query, how can I convert the value of %Empty and %Occupied to Percentage instead of decimal? then add the % sign?<BR /> Thanks a lot!</P> <P>| chart values(NOOFEMPTYLOCATIONS) AS EMPTY eval(values(NOOFLOCATIONS)-values(NOOFEMPTYLOCATIONS)) as OCCUPIED eval(values(NOOFEMPTYLOCATIONS)/values(NOOFLOCATIONS)) as %EMPTY eval((values(NOOFLOCATIONS)-values(NOOFEMPTYLOCATIONS))/values(NOOFLOCATIONS)) as %OCCUPIED by Aisle</P> Sat, 17 Feb 2018 12:26:01 GMT auaave 2018-02-17T12:26:01Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-decimal-numbers-to-percentage/m-p/297241#M89679 <P>Hi guys,</P> <P>With my below query, how can I convert the value of %Empty and %Occupied to Percentage instead of decimal? then add the % sign?<BR /> Thanks a lot!</P> <P>| chart values(NOOFEMPTYLOCATIONS) AS EMPTY eval(values(NOOFLOCATIONS)-values(NOOFEMPTYLOCATIONS)) as OCCUPIED eval(values(NOOFEMPTYLOCATIONS)/values(NOOFLOCATIONS)) as %EMPTY eval((values(NOOFLOCATIONS)-values(NOOFEMPTYLOCATIONS))/values(NOOFLOCATIONS)) as %OCCUPIED by Aisle</P> Sat, 17 Feb 2018 12:26:01 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-decimal-numbers-to-percentage/m-p/297241#M89679 auaave 2018-02-17T12:26:01Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-decimal-numbers-to-percentage/m-p/297242#M89680 <P>try:</P> <PRE><CODE>...|eval %EMPTY =round(%EMPTY*100)."%", %OCCUPIED=round(%OCCUPIED*100)."%" </CODE></PRE> Sat, 17 Feb 2018 12:34:42 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-decimal-numbers-to-percentage/m-p/297242#M89680 493669 2018-02-17T12:34:42Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-decimal-numbers-to-percentage/m-p/297243#M89681 <P>When changing only display</P> <PRE><CODE>|fieldformat %EMPTY=tostring('%EMPTY'*100)."%" |fieldformat %OCCUPIED=tostring('%OCCUPIED'*100)."%" </CODE></PRE> Sat, 17 Feb 2018 15:42:10 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-decimal-numbers-to-percentage/m-p/297243#M89681 HiroshiSatoh 2018-02-17T15:42:10Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-decimal-numbers-to-percentage/m-p/297244#M89682 <P>I got an error so I fixed it</P> <PRE><CODE>...|eval %EMPTY=round('%EMPTY'*100)."%", %OCCUPIED=round('%OCCUPIED'*100)."%" </CODE></PRE> Sat, 17 Feb 2018 15:45:13 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-decimal-numbers-to-percentage/m-p/297244#M89682 HiroshiSatoh 2018-02-17T15:45:13Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-decimal-numbers-to-percentage/m-p/297245#M89683 <P>@auaave when you are aliasing the field name it is better you do not have special character i.e. <CODE>%</CODE>. That should be your final step before presenting to users i.e. <CODE>| rename EMPTY_PERC as "Empty %"</CODE></P> <P>Which is the visualization you are using? Most Visualization settings allow you to round off the value without decimal using <CODE>Number Formatting</CODE> and also change the display unit as per your needs like <CODE>%</CODE>, <CODE>KBs</CODE> etc.</P> <P>In other words if you can give your current output with expected, the solution can be directly in <CODE>UI Edit</CODE> options to <CODE>Format Visualization</CODE></P> Sun, 18 Feb 2018 03:11:37 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-decimal-numbers-to-percentage/m-p/297245#M89683 niketn 2018-02-18T03:11:37Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-decimal-numbers-to-percentage/m-p/297246#M89684 <P>@niketnilay, thanks a lot for your advise. I will be using the stacked column chart for the %empty and %occupied, then include the statistics with the values. </P> Sun, 18 Feb 2018 10:46:39 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-decimal-numbers-to-percentage/m-p/297246#M89684 auaave 2018-02-18T10:46:39Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-decimal-numbers-to-percentage/m-p/297247#M89685 <P>thanks @493669 and @HiroshiSatoh! this works for me! Appreciate your help guys! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Sun, 18 Feb 2018 10:48:19 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-decimal-numbers-to-percentage/m-p/297247#M89685 auaave 2018-02-18T10:48:19Z