topic Re: How to round decimal values up to 2 digits after the decimal in a Splunk search? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-to-round-decimal-values-up-to-2-digits-after-the-decimal-in/m-p/287894#M87143 <P>You can use the eval command<BR /> linux-cpu | search application=pc4_BizX host= sub_module= | stats avg(pctIdle) AS pctLoad avg(pctUser) as pctUser avg(pctSystem) as pctSystem avg(pctNice) as pctNice avg(pctIowait) as pctIowait by sub_module | eval sub_module=round(sub_module,2) |eval pctLoad=round(pctLoad,2) | rename sub_module AS "Sub Module" pctLoad AS "CPU %"</P> <P>Reference:<BR /> <A href="http://docs.splunk.com/Documentation/Splunk/6.3.0/SearchReference/Eval" target="_blank">http://docs.splunk.com/Documentation/Splunk/6.3.0/SearchReference/Eval</A> </P> Tue, 29 Sep 2020 07:42:52 GMT mtranchita 2020-09-29T07:42:52Z How to round decimal values up to 2 digits after the decimal in a Splunk search? https://community.splunk.com/t5/Splunk-Search/How-to-round-decimal-values-up-to-2-digits-after-the-decimal-in/m-p/287893#M87142 <P>I am using below query :</P> <PRE><CODE>`linux-cpu` | search application=pc4_BizX host=* sub_module=* | stats avg(pctIdle) AS pctLoad avg(pctUser) as pctUser avg(pctSystem) as pctSystem avg(pctNice) as pctNice avg(pctIowait) as pctIowait by sub_module | rename sub_module AS "Sub Module" pctLoad AS "CPU %" </CODE></PRE> <P>Getting results like below:</P> <PRE><CODE>Sub Module CPU % pctUser pctSystem pctNice pctIowait pc4_BizX 87.290618 0.000000 1.068261 0.439008 0.000000 pc4_BizX_A 95.066103 0.054263 0.026636 0.544853 0.000155 pc4_BizX_W 98.705398 0.000000 0.019912 0.544605 0.000000 </CODE></PRE> <P>How do I round up to 2 digits after the decimal? Here I am getting 6 digits after the decimal. </P> Mon, 26 Oct 2015 11:38:56 GMT https://community.splunk.com/t5/Splunk-Search/How-to-round-decimal-values-up-to-2-digits-after-the-decimal-in/m-p/287893#M87142 splunksurekha 2015-10-26T11:38:56Z Re: How to round decimal values up to 2 digits after the decimal in a Splunk search? https://community.splunk.com/t5/Splunk-Search/How-to-round-decimal-values-up-to-2-digits-after-the-decimal-in/m-p/287894#M87143 <P>You can use the eval command<BR /> linux-cpu | search application=pc4_BizX host= sub_module= | stats avg(pctIdle) AS pctLoad avg(pctUser) as pctUser avg(pctSystem) as pctSystem avg(pctNice) as pctNice avg(pctIowait) as pctIowait by sub_module | eval sub_module=round(sub_module,2) |eval pctLoad=round(pctLoad,2) | rename sub_module AS "Sub Module" pctLoad AS "CPU %"</P> <P>Reference:<BR /> <A href="http://docs.splunk.com/Documentation/Splunk/6.3.0/SearchReference/Eval" target="_blank">http://docs.splunk.com/Documentation/Splunk/6.3.0/SearchReference/Eval</A> </P> Tue, 29 Sep 2020 07:42:52 GMT https://community.splunk.com/t5/Splunk-Search/How-to-round-decimal-values-up-to-2-digits-after-the-decimal-in/m-p/287894#M87143 mtranchita 2020-09-29T07:42:52Z Re: How to round decimal values up to 2 digits after the decimal in a Splunk search? https://community.splunk.com/t5/Splunk-Search/How-to-round-decimal-values-up-to-2-digits-after-the-decimal-in/m-p/287895#M87144 <P>Thanks it worked !!!</P> Mon, 26 Oct 2015 12:41:11 GMT https://community.splunk.com/t5/Splunk-Search/How-to-round-decimal-values-up-to-2-digits-after-the-decimal-in/m-p/287895#M87144 splunksurekha 2015-10-26T12:41:11Z