round fuction usage for avg command output

Question

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

Accepted Answer

3	What have you tried already when you tried to round? Something like this works with my setup; `\| stats avg(duration) as Avg_duration \| eval Avg_duration=round(Avg_duration,0)` link answered 30 May '12, 03:07 Drainy 8.2k●6●17 accept rate: 24%

round fuction usage for avg command output

Follow this question

Splunk Resources

Related questions