Top speed historic chart?

[detritu5]

Is there any option to see the top speed ever registered in the database? Or can I add a Historical chart to see the best top speed with the date registered? It would be interested

[ronajon]

i second that.
a grafana page with all sorts of top would be great

top speed
top distance per day
top charging speeds
top ...

[dennisbos84]

For top-speed 'positions' you can try on the cli:
docker exec -it teslamate_database_1 psql -U teslamate -c "select date, latitude, longitude, speed from positions where speed is not null order by speed desc limit 10;"

Or for the max-speed per 'drive':
docker exec -it teslamate_database_1 psql -U teslamate -c "select date(a.start_date) as date, date_trunc('second', a.start_date::time) as start_time, date_trunc('second', a.end_date::time) as end_time, a.speed_max, a.power_max, b.name as start_location, c.name as end_location from drives a left join addresses b on a.start_address_id = b.id left join addresses c on a.end_address_id = c.id where a.speed_max is not null order by a.speed_max desc limit 10;"

[DrMichael]

Well, one could do something like

[detritu5]

Well, one could do something like

Yeah that's great!! could you share the json code?

[DrMichael]

Sure...Comments welcome.

top-values-by-period.zip

[rsunny2012]

what is the location of the file to edit on my docker ubuntu image ?

[M1kep]

Not really sure what's changed, but I've updated one of the date_trunc calls that was failing for me
top-values-by-period-fixed.json.zip