Hi,
I have below SPL, which return todays count vs yesterday count and difference between them. I want to see, if i run this search on monday, then the "yesterday" should be last Friday data instea...
See more...
Hi,
I have below SPL, which return todays count vs yesterday count and difference between them. I want to see, if i run this search on monday, then the "yesterday" should be last Friday data instead of weekend. could you pls help ?
SPL:
base search earliest=@d latest=now
| append
[ base search earliest=-1d@d latest=-1d ]
| eval Day=if(_time<relative_time(now(),"@d"),"Yesterday","Today")
| chart count by Name, Day
| eval percentage_variance=abs(round(((Yesterday-Today)/Yesterday)*100,2))
| table Name Today Yesterday percentage_variance