If you paste this into your search window, you can see it being done with your example dataset | makeresults
| eval _raw="DATE,Start_Time,End_Time
Day_3,2023-09-12 01:12:12.123,2023-09-13 01:13:13.1...
See more...
If you paste this into your search window, you can see it being done with your example dataset | makeresults
| eval _raw="DATE,Start_Time,End_Time
Day_3,2023-09-12 01:12:12.123,2023-09-13 01:13:13.123
Day_2,2023-09-11 01:11:11.123,2023-09-12 01:12:12.123
Day_1,2023-09-10 01:10:10.123,2023-09-11 01:11:11.123"
| multikv forceheader=1
| table DATE Start_Time End_Time
| eval _time = relative_time(strptime(Start_Time, "%F %T.%Q"), "@d")
| append [
| makeresults
| eval _raw="Event type,Time,Others
EventID2,2023-09-11 01:20:20.123,
EventID1,2023-09-11 01:11:11.123,
EventID9,2023-09-10 01:20:30.123,
EventID3,2023-09-10 01:20:10.123,
EventID5,2023-09-10 01:10:20.123,
EventID1,2023-09-10 01:10:10.123,"
| multikv forceheader=1
| table Event_type Time
| eval _time = strptime(Time, "%F %T.%Q")
| fields - Time
]
| bin _time span=1d
| stats list(*) as * count by _time but the way you should do this is to search source1 OR search source2
| eval _time = if(event=from_source_1,
relative_time(strptime(Start_Time, "%F %T.%Q"), "@d"),
strptime(Time, "%F %T.%Q"))
| bin _time span=1d
| stats list(*) as * count by _time so this will create a _time field for the source 1 events that is the start of the day, it creates a _time field based on source 2 event times and then uses BIN to create a 1 day grouping and then stats list to collect them together. Count will always be one more than the source 2 events. Note that this assumes each source 1 event only occurs once on a day assumes that source 2 events will not occur outside the time range of source 1 range