So here is my first attempt to track Miles per kWh on my Trip dashboard. Hope it is useful for someone else.
Query is:
SELECT UNIX_TIMESTAMP(StartDate)*1000 as StartDate, UNIX_TIMESTAMP(EndDate)*1000 as EndDate,
Start_address, End_address, km_diff / 1.609344 as km_diff, consumption_kWh...