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...
Those are different buses. Change the formula to return null instead.
My apologies, just noticed the mistake. When I sent the sample data I sorted it by Bus, the original data file comes with the IDs mixed, we have over 100 buses and data for them can come at the same time but recorded in different rows.
It looks something like this:
bus1 - time - value
bus1 - time - value
bus2 - time - vaue
bus1 - time - value
bus3 - time - value
.....
Hopefully this makes sense.