Thanks for your reply , here are more detailed requirement, I've got some logs I need to join and put on the same row and difference values . Index1 events: (base query: index=index1 playbook=100) "Playbook":"100","update_time":"2021-09-27T10:51:16.572759Z","container":"1497" "Playbook":"100","update_time":"2021-09-27T10:52:16.572759Z","container":"1498" "Playbook":"100","update_time":"2021-09-27T10:53:16.572759Z","container":"1499" ........ Index2 events (base query: index=index2 😞 "container":"1497","start_time":"2021-09-26T8:53:16.232759Z" "container":"1498","start_time":"2021-09-25T8:53:16.232759Z" ..... Desired output: container start_time update_time time_diff(update_time-start_time) 1497 2021-09-26T8:53:16.232759Z 2021-09-27T10:51:16.572759Z xxx 1498 2021-09-25T8:53:16.232759Z 2021-09-27T10:52:16.572759Z xxxx 1499 .... Appreciated for any comments.
... View more