Hello, I am trying to get the following results in the table using following query however query seems to be not working correctly can someone please guide on this ? RESULTS Expected : Consumer MaxTPS MinTPS AvgTPS peakTime TEST1 123 60 45 11/09/22 09:47:08 Query : index=whatever yoursearchterms | bin _time span=1s | stats count AS TPS by _time service | eventstats max(TPS) as peakTPS | eval peakTime=if(peakTPS==TPS,_time,null()) | stats max(TPS) AS "MaxTPS" min(TPS) AS "MinTPS" avg(TPS) AS "AvgTPS" first(peakTime) as peakTime by service AS Consumer | fieldformat peakTime=strftime(peakTime,"%x %X") | table Consumer MaxTPS MinTPS AvgTPS peakTime
... View more