HI,
I want to get the max TPS over period of time per day (last 2 months). Any idea what would be the ideal way to do this?
I tried a query but i am not sure to get it per day
index=xyz host=xyz*web* NOT _ui AND NOT medias AND NOT "/backoffice" AND "HTTP/1.1\" 200" | timechart span=1s count AS TPS | eventstats max(TPS) as peakTPS | eval peakTime=if(peakTPS==TPS,_time,null()) | stats avg(TPS) as avgTPS first(peakTPS) as peakTPS
... View more