Hi @bowesmana Thanks for the help. But I see count is not matching for the last week same day using the below query though its totally working fine for today's count. Could you please help. index=sold (earliest=-d@d latest=now) OR (earliest=-7d@d latest=-6d@d)
| eval Today=if(_time>=relative_time(now(), "@d"), 1, null())
| stats count(eval(if(isnull(Today), 1, null()))) as LastWeek count(eval(if(isnotnull(Today), 1, null()))) as Today by Product
... View more