How to get average, max TPS by Method

[sg86sourav]

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 -- ? -- ? -- ? -- ?

[xpac]

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

[sg86sourav]

What is TPS ? Is it a inbuild field ?

[xpac]

Sorry, that was a misunderstanding, I thought that was a field from your events. What do you mean by transactions? Events?