Forum Discussion
Calculating time between rows
Hi Team, We're having trouble calculating time elapsed for vehicles that are idling. Sensor data for each vehicle is being sent and we need to know how much time a vehicle (bus_id) has spent in i...
Let's only take a look at bus 2
| ID | bus_id | sensor_value | date1 | time1 | Date | Expected | | ----- | ------- | ------------ | --------- | ---------- | -------------------- | -------- | | 14618 | Bus_002 | 699.75 | 9/25/2024 | 2:29:27 PM | 9/25/2024 2:29:27 PM | 0 | | 14619 | Bus_002 | 700.25 | 9/25/2024 | 2:29:28 PM | 9/25/2024 2:29:28 PM | 1 | | 14620 | Bus_002 | 701 | 9/25/2024 | 2:29:28 PM | 9/25/2024 2:29:28 PM | 0 | | 14621 | Bus_002 | 699.875 | 9/25/2024 | 2:29:28 PM | 9/25/2024 2:29:28 PM | 0 | | 14622 | Bus_002 | 699.25 | 9/25/2024 | 2:29:32 PM | 9/25/2024 2:29:32 PM | 4 | | 14634 | Bus_002 | 700.125 | 9/25/2024 | 2:29:36 PM | 9/25/2024 2:29:36 PM | 4 | | 14635 | Bus_002 | 699.875 | 9/25/2024 | 2:29:36 PM | 9/25/2024 2:29:36 PM | 0 | | 14636 | Bus_002 | 699.625 | 9/25/2024 | 2:29:36 PM | 9/25/2024 2:29:36 PM | 0 | | 14637 | Bus_002 | 699.375 | 9/25/2024 | 2:29:37 PM | 9/25/2024 2:29:37 PM | 1 | | 14638 | Bus_002 | 700.75 | 9/25/2024 | 2:29:37 PM | 9/25/2024 2:29:37 PM | 1 | | 14639 | Bus_002 | 700.375 | 9/25/2024 | 2:29:37 PM | 9/25/2024 2:29:37 PM | 1 | | 14900 | Bus_002 | 700.25 | 9/25/2024 | 2:31:58 PM | 9/25/2024 2:31:58 PM | 141 |
could you pls explain how we get the expected output? why the last one is 141?
