topic Re: compare event count today vs yesterday vs last week vs prior week in Splunk Search

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

john_q — Thu, 16 Aug 2018 06:31:47 GMT

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

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

jkat54 — Thu, 16 Aug 2018 08:20:58 GMT

Will these work?

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

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

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

john_q — Thu, 16 Aug 2018 08:54:53 GMT

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.

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

jkat54 — Thu, 16 Aug 2018 09:59:54 GMT

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

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

john_q — Thu, 16 Aug 2018 10:29:45 GMT

can you provide a sample full search for this??