index= xxxxxx sourcetype=xxxxxx
| eval import_time=strftime(_time, "%Y-%m-%d:%H")
| eval import_timeday=strftime(_time, "%Y-%m-%d")
| eventstats latest(import_time) as Last by import_timeday
| where Last = import_time
| timechart count by Product
with this search the output seems to be hourly instead of daily
Can some one help in sending SPL to see results daily
Thanks in advance
index= xxxxxx sourcetype=xxxxxx
| eval import_time=strftime(_time, "%Y-%m-%d:%H")
| eval import_timeday=strftime(_time, "%Y-%m-%d")
| eventstats latest(import_time) as Last by import_timeday
| where Last = import_time
| timechart span=1d count by Product