Calculate max TPS over period of time (2 months) everyday

[dantu]

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

[ssadanala1]

index=xyz host=xyz*web* NOT _ui AND NOT medias AND NOT "/backoffice" AND "HTTP/1.1\" 200"|bin _time span=1d | stats max(TPS) as c by _time .

Gives you maximum vlaues of TPS per day

or you can use

index=xyz host=xyz*web* NOT _ui AND NOT medias AND NOT "/backoffice" AND "HTTP/1.1\" 200"| timechart span=1d max(current_size) as c

[dantu]

but this wont give me the TPS right? span here is 1d?