I have a leasing car for 36 months that I’m currently tracking in google sheet.
For these 36 months Im allowed to drive 4 500 (Swedish miles) 45 000 km.
I have no added an integration with the Kia so the odometer of the car is updating every 30 minutes so so.
My goal is to create a chart (based on apex-chart integration) that can track the expected and the outcome of the km.
I basically need help adding/populating the expected usage data and the odometer data in to the same chart so I can track the outcome every day or week.
Odometer is in km:
Odometer sensor entity:
Example I’ve done in google sheet (blue is the expected line to follow, red is the actual outcome. I need to stay under the blue line after 36 month or it gets expensive… - I have manually updated these data points every Sunday…)