compare event count today vs yesterday vs last week vs prior week

[john_q]

Hi,

i want to compare event count today with yesterday,last week and prior week using timewarp complete day like day starting to till now

[jkat54]

Will these work?

... | bin span=1d _time | stats count by _time

And same search but 1w instead of 1d (for weeks instead of days)

[john_q]

hi @jkat54 thnaks for your answer but I want to compare the today event count with yesterday , last and prior week event counts like in the form of line chart like 4 legends.

[jkat54]

Yeah, so you do the search above and select the weeks/days you want to chart with your time picker.

[john_q]

can you provide a sample full search for this??