I know we have addcoltotals if we want to get total for the specified column. Do we have any function or any way of getting the average of the columns? So the output should be like below.
Thanks for your help.
yoursearchhere | stats avg(RT) as "Avg RT by JVM"by JVM | eventstats avg(RT) as overallAverage
This doesn't look like the output you describe, but it will work and it is pretty efficient.
To get exactly what you want, you could do the following, although it takes twice as long:
yoursearchhere | stats avg(RT) by JVM | append [ search yoursearchhere | stats avg(RT) | eval JVM="Average" ]
Let me know if this doesn't work...
Thank you 2nd one worked fine. But first one, i had to chage it little bit..i have it like this..
| stats avg(RT) as "Avg RT by JVM" by JVM
| eventstats avg(Avg RT by JVM) as overallAverage
is that correct?