Talking of pros, does anyone know how I can make a panel within Grafana to display the max power/ top speed output from all drives? From the driving panel, I can see speed but it seems an average rather than top but within each journey, it does contain top.
What output do you want? Just one figure for your highest speed or highest speed per drive in a table of drives? Edit: Ditto power
Is there any way of getting the full vehicle details via TeslaMate? I'm talking this endpoint specifically: Vehicle Config
TBH I don't mind, whichever is the easiest to implement. If I had to choose I'd say ideally the highest speed per drive. The speed within each drive is already present in the drives table, but it's an average instead of the top, which then I have to click into each individual drive.
you can use the python library: tdorssers/TeslaPy then use the python api, or issue a python command and it'll come back. shouldn't too hard
Thanks! I have no idea what it was - great thing of docker is just delete containers and start over .. worked on my dev server.. then just ported to my NAS !
Not too sure on how to share these, but try this. For Max speed across drives: { "description": "", "fieldConfig": { "defaults": { "custom": { "align": null, "filterable": false }, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "mappings": [] }, "overrides": [ { "matcher": { "id": "byName", "options": "Time" }, "properties": [ { "id": "custom.width", "value": 190 } ] } ] }, "gridPos": { "h": 7, "w": 9, "x": 0, "y": 0 }, "id": 28, "options": { "reduceOptions": { "values": false, "calcs": [ "mean" ], "fields": "" }, "orientation": "auto", "textMode": "auto", "colorMode": "value", "graphMode": "area", "justifyMode": "auto" }, "pluginVersion": "7.3.7", "targets": [ { "format": "table", "group": [], "metricColumn": "none", "rawQuery": true, "rawSql": "SELECT\n\tconvert_km(max(speed), '$length_unit') AS \"Speed [$length_unit/h]\"\n\nFROM\n\tpositions\nWHERE\n car_id = $car_id\n \n", "refId": "A", "select": [ [ { "params": [ "odometer" ], "type": "column" } ] ], "table": "positions", "timeColumn": "date", "timeColumnType": "timestamp", "where": [ { "name": "$__timeFilter", "params": [], "type": "macro" } ] } ], "timeFrom": null, "timeShift": null, "title": "Max Speed", "type": "stat", "datasource": null }
For Power: { "fieldConfig": { "defaults": { "custom": {}, "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "mappings": [] }, "overrides": [] }, "gridPos": { "h": 7, "w": 9, "x": 9, "y": 0 }, "id": 30, "options": { "reduceOptions": { "values": false, "calcs": [ "mean" ], "fields": "" }, "orientation": "auto", "textMode": "auto", "colorMode": "value", "graphMode": "area", "justifyMode": "auto" }, "pluginVersion": "7.3.7", "targets": [ { "format": "table", "group": [], "metricColumn": "none", "rawQuery": true, "rawSql": "SELECT\n\tmax(power) AS \"Power [kW]\"\n\nFROM\n\tpositions\nWHERE\n car_id = $car_id\n \n", "refId": "A", "select": [ [ { "params": [ "odometer" ], "type": "column" } ] ], "table": "positions", "timeColumn": "date", "timeColumnType": "timestamp", "where": [ { "name": "$__timeFilter", "params": [], "type": "macro" } ] } ], "timeFrom": null, "timeShift": null, "title": "Max Power", "type": "stat", "datasource": null }
Both worked flawlessly thank you so much! Would it be difficult to link or show the drive when that highest value was done? I don't know if that's complicating things or if it would be easier to amend the average speed that's currently being shown in the default, showing the max instead?