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...
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Here's the sampel data arranged to look like ou table.
| 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 |
| 14901 | Bus_003 | 699.75 | 9/25/2024 | 2:31:58 PM | 9/25/2024 2:31:58 PM | 0 |
| 14902 | Bus_003 | 699.875 | 9/25/2024 | 2:31:59 PM | 9/25/2024 2:31:59 PM | 1 |
| 14903 | Bus_003 | 700.125 | 9/25/2024 | 2:31:59 PM | 9/25/2024 2:31:59 PM | 0 |
| 14904 | Bus_003 | 700.5 | 9/25/2024 | 2:32:03 PM | 9/25/2024 2:32:03 PM | 4 |
| 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 |
| 14931 | Bus_003 | 700 | 9/25/2024 | 2:32:13 PM | 9/25/2024 2:32:13 PM | 10 |
| 14932 | Bus_003 | 699.625 | 9/25/2024 | 2:32:13 PM | 9/25/2024 2:32:13 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 |
| 14936 | Bus_003 | 701 | 9/25/2024 | 2:32:15 PM | 9/25/2024 2:32:14 PM | 2 |
| 14937 | Bus_003 | 699.875 | 9/25/2024 | 2:32:16 PM | 9/25/2024 2:32:15 PM | 1 |
| 14938 | Bus_003 | 700.5 | 9/25/2024 | 2:32:16 PM | 9/25/2024 2:32:15 PM | 0 |
| 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 |
| 14933 | Bus_003 | 701.25 | 9/25/2024 | 2:32:14 PM | 9/25/2024 2:32:15 PM | 0 |
| 14934 | Bus_003 | 699.5 | 9/25/2024 | 2:32:15 PM | 9/25/2024 2:32:16 PM | 1 |
| 14935 | Bus_003 | 699.5 | 9/25/2024 | 2:32:15 PM | 9/25/2024 2:32:16 PM | 0 |
| 14939 | Bus_003 | 700.25 | 9/25/2024 | 2:32:16 PM | 9/25/2024 2:32:16 PM | 0 |