You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
Suggest to add cost per mile to the charges dashboard. Here's the dashboard JSON for
grafana/dashboards/charges.json{ "annotations": { "list": [ { "builtIn": 1, "datasource": "-- Grafana --", "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "type": "dashboard" } ] }, "editable": true, "gnetId": null, "graphTooltip": 0, "iteration": 1619843844984, "links": [ { "icon": "dashboard", "tags": [], "title": "TeslaMate", "tooltip": "", "type": "link", "url": "[[base_url:raw]]" }, { "asDropdown": true, "icon": "external link", "tags": [ "tesla" ], "title": "Dashboards", "type": "dashboards" } ], "panels": [ { "collapsed": false, "datasource": null, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 0 }, "id": 8, "panels": [], "repeat": "car_id", "scopedVars": { "car_id": { "selected": false, "text": "Eevee", "value": "1" } }, "title": "$car_id", "type": "row" }, { "columns": [], "datasource": "TeslaMate", "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "fontSize": "100%", "gridPos": { "h": 19, "w": 24, "x": 0, "y": 1 }, "id": 6, "links": [], "pageSize": null, "scopedVars": { "car_id": { "selected": false, "text": "Eevee", "value": "1" } }, "scroll": false, "showHeader": true, "sort": { "col": 5, "desc": true }, "styles": [ { "alias": "Date", "align": "auto", "dateFormat": "YYYY-MM-DD HH:mm:ss", "link": true, "linkTargetBlank": false, "linkTooltip": "View charge details", "linkUrl": "d/BHhxFeZRz?from=${__cell_0}&to=${__cell_1}&var-car_id=${__cell_3}&var-charging_process_id=${__cell_4}", "pattern": "start_date_km", "type": "date" }, { "alias": "Date", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "MM/DD/YY h:mm:ss a", "decimals": 2, "link": true, "linkTargetBlank": false, "linkTooltip": "View charge details", "linkUrl": "d/BHhxFeZRz?from=${__cell_0}&to=${__cell_1}&var-car_id=${__cell_3}&var-charging_process_id=${__cell_4}", "mappingType": 1, "pattern": "start_date_mi", "thresholds": [], "type": "date", "unit": "short" }, { "alias": "Added", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "charge_energy_added", "thresholds": [], "type": "number", "unit": "kwatth" }, { "alias": "% Start", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 0, "mappingType": 1, "pattern": "start_battery_level", "thresholds": [], "type": "number", "unit": "percent" }, { "alias": "% End", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 0, "mappingType": 1, "pattern": "end_battery_level", "thresholds": [], "type": "number", "unit": "percent" }, { "alias": "Duration", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 1, "mappingType": 1, "pattern": "duration_min", "thresholds": [], "type": "number", "unit": "m" }, { "alias": "Temp", "align": "auto", "colorMode": "value", "colors": [ "#C0D8FF", "#C8F2C2", "#FFA6B0" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 1, "mappingType": 1, "pattern": "outside_temp_avg_c", "thresholds": [ "10", "20" ], "type": "number", "unit": "celsius" }, { "alias": "Cost", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "link": true, "linkTargetBlank": false, "linkTooltip": "Set Cost", "linkUrl": "[[base_url:raw]]/charge-cost/${__cell_4:raw}", "mappingType": 1, "pattern": "cost", "thresholds": [], "type": "number", "unit": "none" }, { "alias": "", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "/.*_ts/", "thresholds": [], "type": "hidden", "unit": "short" }, { "alias": "", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "id", "thresholds": [], "type": "hidden", "unit": "short" }, { "alias": "Location", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "link": true, "linkTargetBlank": true, "linkTooltip": "Create or edit geo-fence", "linkUrl": "[[base_url:raw]]/geo-fences/${__cell_2:raw}", "mappingType": 1, "pattern": "address", "thresholds": [], "type": "string", "unit": "short" }, { "alias": "Driven", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 0, "mappingType": 1, "pattern": "distance_km", "thresholds": [], "type": "number", "unit": "lengthkm" }, { "alias": "kW", "align": "auto", "colorMode": "value", "colors": [ "#96D98D", "#56A64B", "#37872D" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 1, "mappingType": 1, "pattern": "charge_energy_added_per_hour", "thresholds": [ "20", "55" ], "type": "number", "unit": "kwatt" }, { "alias": "km / h", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 0, "mappingType": 1, "pattern": "range_added_per_hour_km", "thresholds": [], "type": "number", "unit": "lengthkm" }, { "alias": "Temp", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 1, "mappingType": 1, "pattern": "outside_temp_avg_f", "thresholds": [], "type": "number", "unit": "fahrenheit" }, { "alias": "Driven", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 0, "mappingType": 1, "pattern": "distance_mi", "thresholds": [], "type": "number", "unit": "lengthmi" }, { "alias": "mi / h", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 0, "mappingType": 1, "pattern": "range_added_per_hour_mi", "thresholds": [], "type": "number", "unit": "none" }, { "alias": "", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "path", "thresholds": [], "type": "hidden", "unit": "short" }, { "alias": "Used", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "link": false, "linkTooltip": "", "linkUrl": "", "mappingType": 1, "pattern": "charge_energy_used", "thresholds": [], "type": "number", "unit": "kwatth" }, { "alias": "Confidence", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 0, "link": false, "mappingType": 1, "pattern": "charge_energy_used_confidence", "thresholds": [], "type": "hidden", "unit": "none" }, { "alias": "Efficiency", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 0, "mappingType": 1, "pattern": "charging_efficiency", "thresholds": [], "type": "number", "unit": "percentunit" }, { "alias": "", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "car_id", "thresholds": [], "type": "hidden", "unit": "short" }, { "alias": "", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "end_date", "thresholds": [], "type": "hidden", "unit": "short" }, { "alias": "", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "decimals": 2, "pattern": "/.*/", "thresholds": [], "type": "number", "unit": "short" } ], "targets": [ { "format": "table", "group": [], "metricColumn": "none", "rawQuery": true, "rawSql": "WITH data AS (\n SELECT\n (round(extract(epoch FROM start_date) - 10) * 1000) AS start_date_ts,\n (round(extract(epoch FROM end_date) + 10) * 1000) AS end_date_ts,\n start_date,\n end_date,\n CONCAT_WS(', ', COALESCE(addresses.name, nullif(CONCAT_WS(' ', addresses.road, addresses.house_number), '')), addresses.city) AS address,\n g.name as geofence_name,\n g.id as geofence_id,\n p.latitude,\n p.longitude,\n cp.charge_energy_added,\n cp.charge_energy_used,\n duration_min,\n start_battery_level,\n end_battery_level,\n start_[[preferred_range]]_range_km,\n end_[[preferred_range]]_range_km,\n outside_temp_avg,\n cp.id,\n lag(end_[[preferred_range]]_range_km) OVER (ORDER BY start_date) - start_[[preferred_range]]_range_km AS range_loss,\n p.odometer - lag(p.odometer) OVER (ORDER BY start_date) AS distance,\n cars.efficiency,\n cp.car_id,\n cost,\n max(c.charger_voltage) as max_charger_voltage\n FROM\n charging_processes cp\n\t LEFT JOIN charges c ON cp.id = c.charging_process_id\n LEFT JOIN positions p ON p.id = cp.position_id\n LEFT JOIN cars ON cars.id = cp.car_id\n LEFT JOIN addresses ON addresses.id = cp.address_id\n LEFT JOIN geofences g ON g.id = geofence_id\nWHERE \n cp.car_id = $car_id AND\n $__timeFilter(start_date) AND\n (cp.charge_energy_added IS NULL OR cp.charge_energy_added > 0) AND\n ('${geofence:pipe}' = '-1' OR geofence_id in ($geofence))\nGROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,11,12,13,14,15,16,17,18,21,p.odometer\nORDER BY\n start_date\n)\nSELECT\n start_date_ts,\n end_date_ts,\n CASE WHEN geofence_id IS NULL THEN CONCAT('new?lat=', latitude, '&lng=', longitude)\n WHEN geofence_id IS NOT NULL THEN CONCAT(geofence_id, '/edit')\n END as path,\n car_id,\n id,\n -- Columns\n start_date as start_date_[[length_unit]],\n end_date,\n COALESCE(geofence_name, address) as address, \n duration_min,\n cost,\n charge_energy_added,\n charge_energy_used,\n CASE WHEN charge_energy_used IS NULL THEN NULL ELSE LEAST(charge_energy_added / NULLIF(charge_energy_used, 0), 1.0) END as charging_efficiency,\n convert_celsius(outside_temp_avg, '$temp_unit') AS outside_temp_avg_$temp_unit,\n charge_energy_added * 60 / NULLIF (duration_min, 0) AS charge_energy_added_per_hour,\n convert_km((end_[[preferred_range]]_range_km - start_[[preferred_range]]_range_km) * 60 / NULLIF (duration_min, 0), '$length_unit') AS range_added_per_hour_$length_unit,\n start_battery_level,\n end_battery_level,\n convert_km(distance::numeric, '$length_unit') AS distance_$length_unit\n FROM\n data\nWHERE\n (distance >= 0 OR distance IS NULL)\n AND max_charger_voltage >= '$voltage'\n AND duration_min >= '$min_duration_min'\nORDER BY\n start_date DESC;\n ", "refId": "A", "select": [ [ { "params": [ "value" ], "type": "column" } ] ], "timeColumn": "time", "where": [ { "name": "$__timeFilter", "params": [], "type": "macro" } ] } ], "timeFrom": null, "timeShift": null, "title": "Charges", "transform": "table", "type": "table-old" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": false, "colors": [ "#299c46", "rgba(237, 129, 40, 0.89)", "#d44a3a" ], "datasource": "TeslaMate", "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "format": "kwatth", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 2, "w": 5, "x": 0, "y": 20 }, "id": 10, "interval": null, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "postfix": "", "postfixFontSize": "70%", "prefix": "Energy added:", "prefixFontSize": "50%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "scopedVars": { "car_id": { "selected": false, "text": "Eevee", "value": "1" } }, "sparkline": { "fillColor": "rgba(242, 204, 12, 0.25)", "full": false, "lineColor": "#F2CC0C", "show": false, "ymax": null, "ymin": null }, "tableColumn": "", "targets": [ { "format": "time_series", "group": [], "metricColumn": "none", "rawQuery": true, "rawSql": "SELECT start_date as \"time\", charge_energy_added\nFROM charging_processes\nWHERE \n $__timeFilter(end_date) AND \n car_id = $car_id AND \n ('${geofence:pipe}' = '-1' OR geofence_id in ($geofence))\nORDER BY start_date;", "refId": "A", "select": [ [ { "params": [ "latitude" ], "type": "column" } ] ], "table": "addresses", "timeColumn": "inserted_at", "timeColumnType": "timestamp", "where": [ { "name": "$__timeFilter", "params": [], "type": "macro" } ] } ], "thresholds": "", "timeFrom": null, "timeShift": null, "title": "", "transparent": true, "type": "singlestat", "valueFontSize": "50%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "null" } ], "valueName": "total" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": false, "colors": [ "#299c46", "rgba(237, 129, 40, 0.89)", "#d44a3a" ], "datasource": "TeslaMate", "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "format": "kwatth", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 2, "w": 5, "x": 5, "y": 20 }, "id": 12, "interval": null, "links": [], "mappingType": 1, "mappingTypes": [ { "$$hashKey": "object:519", "name": "value to text", "value": 1 }, { "$$hashKey": "object:520", "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "postfix": "", "postfixFontSize": "70%", "prefix": "Energy used:", "prefixFontSize": "50%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "scopedVars": { "car_id": { "selected": false, "text": "Eevee", "value": "1" } }, "sparkline": { "fillColor": "rgba(255, 120, 10, 0.25)", "full": false, "lineColor": "#FF780A", "show": false, "ymax": null, "ymin": null }, "tableColumn": "", "targets": [ { "format": "time_series", "group": [], "metricColumn": "none", "rawQuery": true, "rawSql": "SELECT start_date as \"time\", greatest(charge_energy_added, charge_energy_used)\nFROM charging_processes\nWHERE \n $__timeFilter(end_date) AND \n car_id = $car_id AND \n ('${geofence:pipe}' = '-1' OR geofence_id in ($geofence))\nORDER BY start_date;", "refId": "A", "select": [ [ { "params": [ "latitude" ], "type": "column" } ] ], "table": "addresses", "timeColumn": "inserted_at", "timeColumnType": "timestamp", "where": [ { "name": "$__timeFilter", "params": [], "type": "macro" } ] } ], "thresholds": "", "timeFrom": null, "timeShift": null, "title": "", "transparent": true, "type": "singlestat", "valueFontSize": "50%", "valueMaps": [ { "$$hashKey": "object:522", "op": "=", "text": "N/A", "value": "null" } ], "valueName": "total" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": false, "colors": [ "#299c46", "rgba(237, 129, 40, 0.89)", "#d44a3a" ], "datasource": "TeslaMate", "decimals": 2, "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "format": "currencyUSD", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 2, "w": 5, "x": 10, "y": 20 }, "id": 14, "interval": null, "links": [], "mappingType": 1, "mappingTypes": [ { "$$hashKey": "object:616", "name": "value to text", "value": 1 }, { "$$hashKey": "object:617", "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "postfix": "", "postfixFontSize": "70%", "prefix": "Cost:", "prefixFontSize": "50%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sparkline": { "fillColor": "rgba(242, 204, 12, 0.25)", "full": false, "lineColor": "#F2CC0C", "show": false, "ymax": null, "ymin": null }, "tableColumn": "", "targets": [ { "format": "time_series", "group": [], "metricColumn": "none", "rawQuery": true, "rawSql": "SELECT start_date as \"time\", cost\nFROM charging_processes\nWHERE \n $__timeFilter(end_date) AND \n car_id = $car_id AND \n ('${geofence:pipe}' = '-1' OR geofence_id in ($geofence))\nORDER BY start_date;", "refId": "A", "select": [ [ { "params": [ "latitude" ], "type": "column" } ] ], "table": "addresses", "timeColumn": "inserted_at", "timeColumnType": "timestamp", "where": [ { "name": "$__timeFilter", "params": [], "type": "macro" } ] } ], "thresholds": "", "timeFrom": null, "timeShift": null, "title": "", "transparent": true, "type": "singlestat", "valueFontSize": "50%", "valueMaps": [ { "$$hashKey": "object:619", "op": "=", "text": "N/A", "value": "null" } ], "valueName": "total" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": false, "colors": [ "#299c46", "rgba(237, 129, 40, 0.89)", "#d44a3a" ], "datasource": "TeslaMate", "decimals": 2, "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "format": "lengthmi", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 2, "w": 5, "x": 15, "y": 20 }, "id": 13, "interval": null, "links": [], "mappingType": 1, "mappingTypes": [ { "$$hashKey": "object:469", "name": "value to text", "value": 1 }, { "$$hashKey": "object:470", "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "postfix": "", "postfixFontSize": "70%", "prefix": "Miles:", "prefixFontSize": "50%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "scopedVars": { "car_id": { "selected": false, "text": "Eevee", "value": "1" } }, "sparkline": { "fillColor": "rgba(242, 204, 12, 0.25)", "full": false, "lineColor": "#F2CC0C", "show": false, "ymax": null, "ymin": null }, "tableColumn": "", "targets": [ { "format": "time_series", "group": [], "metricColumn": "none", "rawQuery": true, "rawSql": "SELECT start_date as \"time\", p.odometer - lag(p.odometer) OVER (ORDER BY start_date) AS distance\nFROM charging_processes cp\n LEFT JOIN positions p ON p.id = cp.position_id\nWHERE \n $__timeFilter(end_date) AND \n cp.car_id = $car_id AND \n ('${geofence:pipe}' = '-1' OR geofence_id in ($geofence))\nORDER BY start_date;", "refId": "A", "select": [ [ { "params": [ "latitude" ], "type": "column" } ] ], "table": "addresses", "timeColumn": "inserted_at", "timeColumnType": "timestamp", "where": [ { "name": "$__timeFilter", "params": [], "type": "macro" } ] } ], "thresholds": "", "timeFrom": null, "timeShift": null, "title": "", "transparent": true, "type": "singlestat", "valueFontSize": "50%", "valueMaps": [ { "$$hashKey": "object:472", "op": "=", "text": "N/A", "value": "null" } ], "valueName": "total" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": false, "colors": [ "#299c46", "rgba(237, 129, 40, 0.89)", "#d44a3a" ], "datasource": "TeslaMate", "decimals": 2, "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "format": "currencyUSD", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 2, "w": 4, "x": 20, "y": 20 }, "id": 15, "interval": null, "links": [], "mappingType": 1, "mappingTypes": [ { "$$hashKey": "object:469", "name": "value to text", "value": 1 }, { "$$hashKey": "object:470", "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "postfix": "", "postfixFontSize": "70%", "prefix": "Cost/mile:", "prefixFontSize": "50%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sparkline": { "fillColor": "rgba(242, 204, 12, 0.25)", "full": false, "lineColor": "#F2CC0C", "show": false, "ymax": null, "ymin": null }, "tableColumn": "", "targets": [ { "format": "time_series", "group": [], "metricColumn": "none", "rawQuery": true, "rawSql": "WITH data AS (\r\n SELECT\r\n (round(extract(epoch FROM start_date) - 10) * 1000) AS start_date_ts,\r\n (round(extract(epoch FROM end_date) + 10) * 1000) AS end_date_ts,\r\n start_date,\r\n end_date,\r\n CONCAT_WS(', ', COALESCE(addresses.name, nullif(CONCAT_WS(' ', addresses.road, addresses.house_number), '')), addresses.city) AS address,\r\n g.name as geofence_name,\r\n g.id as geofence_id,\r\n p.latitude,\r\n p.longitude,\r\n cp.charge_energy_added,\r\n cp.charge_energy_used,\r\n duration_min,\r\n start_battery_level,\r\n end_battery_level,\r\n start_rated_range_km,\r\n end_rated_range_km,\r\n outside_temp_avg,\r\n cp.id,\r\n lag(end_rated_range_km) OVER (ORDER BY start_date) - start_rated_range_km AS range_loss,\r\n p.odometer - lag(p.odometer) OVER (ORDER BY start_date) AS distance,\r\n cars.efficiency,\r\n cp.car_id,\r\n cost,\r\n max(c.charger_voltage) as max_charger_voltage\r\n FROM\r\n charging_processes cp\r\n\t LEFT JOIN charges c ON cp.id = c.charging_process_id\r\n LEFT JOIN positions p ON p.id = cp.position_id\r\n LEFT JOIN cars ON cars.id = cp.car_id\r\n LEFT JOIN addresses ON addresses.id = cp.address_id\r\n LEFT JOIN geofences g ON g.id = geofence_id\r\nWHERE \r\n cp.car_id = $car_id AND\r\n $__timeFilter(start_date) AND\r\n (cp.charge_energy_added IS NULL OR cp.charge_energy_added > 0) AND\r\n ('${geofence:pipe}' = '-1' OR geofence_id in ($geofence))\r\nGROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,11,12,13,14,15,16,17,18,21,p.odometer\r\nORDER BY\r\n start_date\r\n)\r\nSELECT\r\n 1 AS time,\r\n --sum(cost),\r\n --sum(convert_km(distance::numeric, 'mi')) AS distance_mi,\r\n sum(cost)/sum(convert_km(distance::numeric, 'mi')) AS cost_per_mi\r\n FROM\r\n data\r\nWHERE\r\n (distance >= 0 OR distance IS NULL)\r\n AND max_charger_voltage >= '$voltage'\r\n AND duration_min >= '$min_duration_min'\r\n", "refId": "A", "select": [ [ { "params": [ "latitude" ], "type": "column" } ] ], "table": "addresses", "timeColumn": "inserted_at", "timeColumnType": "timestamp", "where": [ { "name": "$__timeFilter", "params": [], "type": "macro" } ] } ], "thresholds": "", "timeFrom": null, "timeShift": null, "title": "", "transparent": true, "type": "singlestat", "valueFontSize": "50%", "valueMaps": [ { "$$hashKey": "object:472", "op": "=", "text": "N/A", "value": "null" } ], "valueName": "total" } ], "schemaVersion": 26, "style": "dark", "tags": [ "tesla" ], "templating": { "list": [ { "allValue": null, "current": { "selected": false, "text": "All", "value": "$__all" }, "datasource": "TeslaMate", "definition": "SELECT name AS __text, id AS __value FROM cars;", "error": null, "hide": 2, "includeAll": true, "label": "Car", "multi": false, "name": "car_id", "options": [], "query": "SELECT name AS __text, id AS __value FROM cars;", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 5, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": null, "current": { "selected": false, "text": "mi", "value": "mi" }, "datasource": "TeslaMate", "definition": "select unit_of_length from settings limit 1;", "error": null, "hide": 2, "includeAll": false, "label": "", "multi": false, "name": "length_unit", "options": [], "query": "select unit_of_length from settings limit 1;", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": null, "current": { "selected": false, "text": "F", "value": "F" }, "datasource": "TeslaMate", "definition": "select unit_of_temperature from settings limit 1;", "error": null, "hide": 2, "includeAll": false, "label": "", "multi": false, "name": "temp_unit", "options": [], "query": "select unit_of_temperature from settings limit 1;", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": null, "current": { "selected": false, "text": "rated", "value": "rated" }, "datasource": "TeslaMate", "definition": "select preferred_range from settings limit 1;", "error": null, "hide": 2, "includeAll": false, "label": null, "multi": false, "name": "preferred_range", "options": [], "query": "select preferred_range from settings limit 1;", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": null, "current": { "selected": false, "text": "http://teslamate.home.me:4000", "value": "http://teslamate.home.me:4000" }, "datasource": "TeslaMate", "definition": "select base_url from settings limit 1;", "error": null, "hide": 2, "includeAll": false, "label": null, "multi": false, "name": "base_url", "options": [], "query": "select base_url from settings limit 1;", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allValue": "-1", "current": { "selected": true, "text": [ "All" ], "value": [ "$__all" ] }, "datasource": "TeslaMate", "definition": "SELECT name AS __text, id AS __value FROM geofences ORDER BY name COLLATE \"C\" ASC;", "error": null, "hide": 0, "includeAll": true, "label": "Geofence", "multi": true, "name": "geofence", "options": [], "query": "SELECT name AS __text, id AS __value FROM geofences ORDER BY name COLLATE \"C\" ASC;", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "current": { "selected": false, "text": "0", "value": "0" }, "error": null, "hide": 0, "label": "Enter min duration (minutes) here", "name": "min_duration_min", "options": [ { "selected": false, "text": "0", "value": "0" } ], "query": "0", "skipUrlSync": false, "type": "textbox" }, { "current": { "selected": false, "text": "0", "value": "0" }, "error": null, "hide": 0, "label": "Enter min voltage here", "name": "voltage", "options": [ { "selected": false, "text": "0", "value": "0" } ], "query": "0", "skipUrlSync": false, "type": "textbox" } ] }, "time": { "from": "now-30d", "to": "now" }, "timepicker": { "refresh_intervals": [ "5s", "10s", "30s", "1m", "5m", "15m", "30m", "1h", "2h", "1d" ], "time_options": [ "5m", "15m", "1h", "6h", "12h", "24h", "2d", "7d", "30d" ] }, "timezone": "", "title": "Charges", "uid": "TSmNYvRRk", "version": 1 }Beta Was this translation helpful? Give feedback.
All reactions