index=abc | stats latest(_time) AS Last_time by day | convert ctime(Last_time) | sort by Last_time desc
for example,
Monday
06/13/2022 13:03:11
Tuesday
06/13/2022 13:03:11
Wednesday
06/13/2022 13:03:11
Thursday
06/13/2022 13:03:11
Friday
06/12/2022 13:03:11
Saturday
06/13/2022 13:03:11
Sunday
06/13/2022 13:03:11
I want the search to return 0 // or something else if there was no event today.
Monday
06/13/2022 13:03:11
Tuesday
06/13/2022 13:03:11
Wednesday
06/13/2022 13:03:11
Thursday
06/13/2022 13:03:11
Friday
0 // or something else
Saturday
06/13/2022 13:03:11
Sunday
06/13/2022 13:03:11
Is that possible.
... View more