LucidLogger

[M5thSD]

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, (km_diff / 1.609344) / consumption_kWh as Miles_per_kWh, (StartRange - EndRange) / 1.609344 as RangeDiff, DurationMinutes, avg_consumption_kWh_100km * 1.609344 as avg_consumption_kWh_100km,
 Round(outside_temp_avg * 9/5 + 32,1) as outside_temp_avg,speed_max / 1.609344 as speed_max,power_max/1.35962 as power_max,power_min/1.35962 as power_min,power_avg/1.35962 as power_avg, (select km_diff / DurationMinutes * 60) / 1.609344 as avg_kmh,
lat, lng, EndLat, EndLng, UNIX_TIMESTAMP(StartDate)*1000 as StartDateRAW, UNIX_TIMESTAMP(EndDate)*1000 as EndDateRAW
from trip WHERE
  $__timeFilter(StartDate) and km_diff < 1000 and CarID = $Car and (Start_address like '%$Textfilter%' or End_address like '%$Textfilter%')

order by StartDate desc

Overrides are: