round funtion usage to round the decimal dgits after the precision

[rakesh_498115]

Hi ,

I have been using the stats avg(duration) as Avg_Duration 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.

Please help me on this .Thanx

[Ayn · Accepted solution]

Just add an eval after your stats command:

... | stats avg(duration) as Avg_Duration | eval Avg_Duration=round(Avg_Duration,4)

[Ayn]

No problem. Could you please mark my answer as accepted? Thanks!

[rakesh_498115]

Thank you so much !

[Ayn]

Upvote returned. 🙂

[Drainy]

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