22 Jun
2018
22 Jun
'18
4:49 p.m.
Hi all:
I'm trying to figure how to calculate the time delta between two events. My events have a timestamp, event source, event type, and an event state and event id.
So an event looks like - event_date_time event_source event_type event_state event_id 2018-06-22 09:05:07.000000 MODULE123 TYPEABC ACK 24567890 2018-06-22 11:32:14.000000 MODULE123 TYPEABC UNACK 24812266
This makes up a unique "event", start to finish. However I have hundreds or thousands of entries between and I want be able to group them together in their unique pairings as above.
I'm not sure how to wrap my head around this one.
Adam Doherty