I wanted some more granular fuel savings data in my Grafana. Made a little dashboard with monthly stats for:
Distance Driven
Average Petrol Price per Litre
Charging Cost Total
Fuel Equivalent
Fuel Savings
Cost Per Mile (EV) vs Cost Per Mile (ICE)
It took a bit of setup including an additional table in the database to store the fuel cost data, which the government kindly provides in excel format:
Monthly and annual prices of road fuels and petroleum products - GOV.UK
View attachment 849990
If anyone wants the JSON file for these panels I can upload it. You need to add a new table in your DB with the fuel prices.