I have a table with meter_readings and dates for various cars in various organizations
Org, Vehicle, Reading, MeterDate
22, 11003-01, 10, 6/01/2020
22, 11003-01, 60, 11/01/2020
22, 11993-01, 500, 16/01/2020
22, 11993-01, 550, 21/01/2020
22, 11993-01, 600, 26/01/2020
23, 902-01, 1000, 17/01/2020
23, 902-01, 1050, 22/01/2020
23, 902-01, 1100, 27/01/2020
I wish to do computations so I could compare the values with the next available row for that car.
Org, Vehicle, Reading MeterDate, NextReading, NextDate
22, 11003-01, 10 6/01/2020, 60 11/01/2020
22, 11003-01, 60 11/01/2020,
22, 11993-01, 500 16/01/2020, 550 21/01/2020
22, 11993-01, 550 21/01/2020, 600 26/01/2020
22, 11993-01, 600 26/01/2020,
23, 902-01, 1000, 17/01/2020, 1050 22/01/2020
23, 902-01, 1050, 22/01/2020, 1100 27/01/2020
23, 902-01, 1100, 27/01/2020,
What combination of nodes do I use?
Have you done something similar?
Are there examples available that I could check out?