Round Value of An Average Value

[nikhilmehra79]

Hi ,

I am getting a average value in my result output but it goes to 6 decimal places....i need to round it to only two - tried couple of things with no luck - can some one please suggest where i am going wrong with this:

.. | stats avg(Latency_msec) as Average_Latency_msec | eval Avg_Latency_msec=round(Avg_Latency_msec,2)

[martin_mueller · Accepted solution]

In the stats you use the full "Average", in the eval you abbreviate to "Avg".

[nikhilmehra79]

aah...thanks