Hi,
I am looking for splunk query which can give average, max and 90th percentile value of transactions per second (TPS) for each of the methods. I am looking a table in below format-
Method Name -- Avg TPS -- Max TPS -- 90th Percentile TPS -- Total Sample
Method1 -- ? -- ? -- ? -- ?
Method2 -- ? -- ? -- ? -- ?
Method3 -- ? -- ? -- ? -- ?
Method4 -- ? -- ? -- ? -- ?
Try this:
index=something yoursearchhere
| stats avg(TPS) AS "Avg TPS" max(TPS) AS "Max TPS" perc90(TPS) AS "90th Percentile TPS" count(TPS) as "Total Sample" by method
What is TPS ? Is it a inbuild field ?
Sorry, that was a misunderstanding, I thought that was a field from your events. What do you mean by transactions? Events?