I have events like
session_id = 1 device_time = 2017-11-26T12:13:32
session_id = 1 device_time = 2017-11-26T12:13:35
session_id = 1 device_time = 2017-11-26T12:13:37
session_id = 2 device_time = 2017-11-26T12:13:41
session_id = 2 device_time = 2017-11-26T12:13:48
session_id = 3 device_time = 2017-11-26T12:13:30
session_id = 4 device_time = 2017-11-26T12:13:21
session_id = 4 device_time = 2017-11-26T12:13:25
session_id = 4 device_time = 2017-11-26T12:13:34
session_id = 4 device_time = 2017-11-26T12:13:38
I would like to calculate time difference between consecutive events within a session, and get result like:
session_id = 1 time_diff = 3
session_id = 1 time_diff = 2
session_id = 2 time_diff = 7
session_id = 4 time_diff = 4
session_id = 4 time_diff = 9
session_id = 4 time_diff = 4
... View more