https://community.splunk.com/t5/Splunk-Search/round-funtion-usage-to-round-the-decimal-dgits-after-the/m-p/63295#M180267 <P>Hi ,</P> <P>I have been using the <STRONG>stats avg(duration) as Avg_Duration</STRONG> in my query.But while displayin the Avg_Duration i am getting the output value with 6 decimal digits after the precision.Something like 2.123456 i would like to round it off to four digits only.Tried using the round function along with the stats command..but it didnt worked.</P> <P>Please help me on this .Thanx</P> Wed, 30 May 2012 08:09:24 GMT rakesh_498115 2012-05-30T08:09:24Z https://community.splunk.com/t5/Splunk-Search/round-funtion-usage-to-round-the-decimal-dgits-after-the/m-p/63295#M180267 <P>Hi ,</P> <P>I have been using the <STRONG>stats avg(duration) as Avg_Duration</STRONG> in my query.But while displayin the Avg_Duration i am getting the output value with 6 decimal digits after the precision.Something like 2.123456 i would like to round it off to four digits only.Tried using the round function along with the stats command..but it didnt worked.</P> <P>Please help me on this .Thanx</P> Wed, 30 May 2012 08:09:24 GMT https://community.splunk.com/t5/Splunk-Search/round-funtion-usage-to-round-the-decimal-dgits-after-the/m-p/63295#M180267 rakesh_498115 2012-05-30T08:09:24Z https://community.splunk.com/t5/Splunk-Search/round-funtion-usage-to-round-the-decimal-dgits-after-the/m-p/63296#M180268 <P>Just add an <CODE>eval</CODE> after your stats command:</P> <PRE><CODE>... | stats avg(duration) as Avg_Duration | eval Avg_Duration=round(Avg_Duration,4) </CODE></PRE> Wed, 30 May 2012 10:13:37 GMT https://community.splunk.com/t5/Splunk-Search/round-funtion-usage-to-round-the-decimal-dgits-after-the/m-p/63296#M180268 Ayn 2012-05-30T10:13:37Z https://community.splunk.com/t5/Splunk-Search/round-funtion-usage-to-round-the-decimal-dgits-after-the/m-p/63297#M180269 <P>Well this is awkward, we both appear to have answered the same question in different threads... suppose I should offer you an upvote as a highfive</P> Wed, 30 May 2012 10:17:31 GMT https://community.splunk.com/t5/Splunk-Search/round-funtion-usage-to-round-the-decimal-dgits-after-the/m-p/63297#M180269 Drainy 2012-05-30T10:17:31Z https://community.splunk.com/t5/Splunk-Search/round-funtion-usage-to-round-the-decimal-dgits-after-the/m-p/63298#M180270 <P>Upvote returned. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 30 May 2012 10:21:18 GMT https://community.splunk.com/t5/Splunk-Search/round-funtion-usage-to-round-the-decimal-dgits-after-the/m-p/63298#M180270 Ayn 2012-05-30T10:21:18Z https://community.splunk.com/t5/Splunk-Search/round-funtion-usage-to-round-the-decimal-dgits-after-the/m-p/63299#M180271 <P>Thank you so much !</P> Thu, 31 May 2012 07:18:33 GMT https://community.splunk.com/t5/Splunk-Search/round-funtion-usage-to-round-the-decimal-dgits-after-the/m-p/63299#M180271 rakesh_498115 2012-05-31T07:18:33Z https://community.splunk.com/t5/Splunk-Search/round-funtion-usage-to-round-the-decimal-dgits-after-the/m-p/63300#M180272 <P>No problem. Could you please mark my answer as accepted? Thanks!</P> Thu, 31 May 2012 09:10:40 GMT https://community.splunk.com/t5/Splunk-Search/round-funtion-usage-to-round-the-decimal-dgits-after-the/m-p/63300#M180272 Ayn 2012-05-31T09:10:40Z