topic Re: How to round stats average to 2 decimal places? in Splunk Search

How to round stats average to 2 decimal places?

markthompson — Wed, 22 Oct 2014 12:50:14 GMT

Hello,
I have this:

stats count by opentime | stats avg(count)

and I want the average to be in 2dp.

Anyone have any suggestions?

Re: How to round stats average to 2 decimal places?

richgalloway — Wed, 22 Oct 2014 13:21:35 GMT

Here is how I do it:

stats count by opentime | stats avg(count) as avg_count | eval avg_count=round(avg_count,2) | ...

Re: How to round stats average to 2 decimal places?

gkanapathy — Wed, 22 Oct 2014 16:37:56 GMT

if you really like the name avg(count) I believe you can do it by quoting the name:

... | stats avg(count) | eval 'avg(count)'=round('avg(count)',2)

Re: How to round stats average to 2 decimal places?

AdsicSplunk — Mon, 12 Mar 2018 05:51:45 GMT

Hi,

I have tried the above but this is not working for me. Could anyone please tell me why round function is not working for me.

Re: How to round stats average to 2 decimal places?

damiensurat — Wed, 03 Apr 2019 15:27:17 GMT

I know this has been around a while, but I felt I should share this with the community. You can incorporate the eval statement into the stats command:
EG:
| stats avg(eval(round(count,0))) AS Avg_Count

[https://docs.splunk.com/Documentation/Splunk/7.2.5/Search/Usestatswithevalexpressionsandfunctions]

Re: How to round stats average to 2 decimal places?

damiensurat — Wed, 03 Apr 2019 15:28:59 GMT

This especially works well when you are using a split by statement.
EG:
| stats avg(eval(round(count,0))) AS Avg_Count by something

Re: How to round stats average to 2 decimal places?

damiensurat — Wed, 03 Apr 2019 15:31:02 GMT

[https://docs.splunk.com/Documentation/Splunk/7.2.5/Search/Usestatswithevalexpressionsandfunctions]

This especially works well when you are using a split by statement.
EG:
| stats avg(eval(round(count,2))) AS Avg_Count by something

Re: How to round stats average to 2 decimal places?

bschandramohan — Mon, 16 Sep 2019 21:44:22 GMT

It didn't actually round the average for me. I think that rounds the count or a field value before applying the average.

Re: How to round stats average to 2 decimal places?

lakromani — Mon, 30 Sep 2019 18:42:10 GMT

I downvoted this post because does not work, since it round the number before its averaged. It will not round the result. Look at this round((4+5)/2) is not the same as (round(4)+round(5))/2

Re: How to round stats average to 2 decimal places?

brettcave — Thu, 30 Jan 2020 11:09:50 GMT

very useful, thanks @damiensurat

Re: How to round stats average to 2 decimal places?

gene_tien — Mon, 25 Jan 2021 13:58:51 GMT

This is great - is there an equivalent way to do with with mstats searches? This syntax doesn't seem to work.

Re: How to round stats average to 2 decimal places?

esalesap — Thu, 04 Mar 2021 05:00:47 GMT

Using eval in stats works, but if you want to round the average, you have to eval(round(avg(count),2)).