Hi dfigurello,
based on the answer by caraaso this works like this:
YourSearchHere earliest=-1w@w
| timechart <insert your search commands to get your event results> span=1h
| timewrap d series=short
| addtotals s*
| table _time, _span, s1, s8
| rename s1 as last_Monday, s8 as this_Monday
This will search YourSearchHere starting at the start of the week before ( -1w@w ), then you will timechart your events to your needs so you get your sales numbers, timewrap it and addtotals . After that you show, according to your question, this Monday and last Monday results with the table command and rename s1 and s8 to human readable names.
I did test it with the index=_internal and it worked, so don't blame me if it will not work with your events 😉
hope this helps ...
cheers, MuS
... View more