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
Just add an eval
after your stats command:
... | stats avg(duration) as Avg_Duration | eval Avg_Duration=round(Avg_Duration,4)
Just add an eval
after your stats command:
... | stats avg(duration) as Avg_Duration | eval Avg_Duration=round(Avg_Duration,4)
No problem. Could you please mark my answer as accepted? Thanks!
Thank you so much !
Upvote returned. 🙂
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