Replies: 5 comments 19 replies
-
|
Example dashboard with JSON using this graph:
Dashboard 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,
"id": 3,
"links": [],
"panels": [
{
"collapsed": false,
"datasource": null,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 0
},
"id": 20,
"panels": [],
"title": "Live Monitoring",
"type": "row"
},
{
"aliasColors": {
"Charge": "red",
"Grid Usage": "purple",
"Home Usage": "blue",
"Powerwall": "green",
"Solar Energy": "yellow",
"Sun altitude": "rgb(192, 192, 192)"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": "-- Mixed --",
"fill": 3,
"fillGradient": 0,
"gridPos": {
"h": 12,
"w": 16,
"x": 0,
"y": 1
},
"hiddenSeries": false,
"id": 2,
"interval": "",
"legend": {
"alignAsTable": false,
"avg": false,
"current": false,
"max": true,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [
{
"alias": "Charge",
"bars": false,
"fill": 0,
"lines": true,
"linewidth": 2,
"yaxis": 2
},
{
"alias": "Sun altitude",
"dashLength": 1,
"dashes": true,
"fill": 1,
"hideTooltip": true,
"legend": false,
"spaceLength": 5,
"yaxis": 2
}
],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "Home Usage",
"datasource": "InfluxDB",
"groupBy": [
{
"params": [
"5m"
],
"type": "time"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT \"mean_load_instant_power\" FROM \"http\" WHERE $timeFilter tz('America/Los_Angeles')",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"home"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
},
{
"alias": "Solar Energy",
"datasource": "InfluxDB",
"groupBy": [
{
"params": [
"5m"
],
"type": "time"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "autogen",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"solar"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
},
{
"alias": "Powerwall",
"datasource": "InfluxDB",
"groupBy": [
{
"params": [
"5m"
],
"type": "time"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT mean(from_pw) - mean(to_pw) FROM autogen.http WHERE $timeFilter GROUP BY time(5m) tz('America/Los_Angeles')",
"rawQuery": true,
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"from_pw+to_pw"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
},
{
"alias": "Grid Usage",
"datasource": "InfluxDB",
"groupBy": [
{
"params": [
"5m"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT mean(from_grid) - mean(to_grid) FROM autogen.http WHERE $timeFilter GROUP BY time(5m) tz('America/Los_Angeles')",
"rawQuery": true,
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"site_instant_power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
},
{
"alias": "Charge",
"datasource": "InfluxDB",
"groupBy": [
{
"params": [
"5m"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT \"mean_percentage\" FROM \"http\" WHERE $timeFilter",
"rawQuery": false,
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"percentage"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
" /0.95 - 5/0.95"
],
"type": "math"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
},
{
"datasource": "Sun and Moon",
"refId": "F",
"target": "sun_altitude"
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Energy Usage",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"decimals": null,
"format": "watt",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"format": "percent",
"label": null,
"logBase": 1,
"max": "101",
"min": "0",
"show": true
}
],
"yaxis": {
"align": true,
"alignLevel": null
}
},
{
"cacheTimeout": null,
"content": "<div style=\"text-align: center\">\n<iframe id=\"frame\" src=\"/public/img/grafana_icon.svg\" width=\"400\" height=\"300\" frameBorder=\"0\">No</iframe>\n<script>\nvar pwurl = window.location.protocol + \"//\" + window.location.hostname + \":8675/\";\nconsole.log(pwurl);\ndocument.getElementById('frame').src = pwurl;\n</script>\n</div>",
"datasource": null,
"gridPos": {
"h": 9,
"w": 8,
"x": 16,
"y": 1
},
"id": 13,
"links": [],
"mode": "html",
"options": {},
"pluginVersion": "6.5.1",
"targets": [
{
"alias": "From Solar",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (1+from_solar/abs(from_solar))*from_solar/2 FROM (SELECT integral(solar)/1000/3600 - integral(to_pw)/1000/3600 - integral(to_grid)/1000/3600 AS from_solar FROM autogen.http WHERE $timeFilter tz('America/Los_Angeles'))",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"solar_5m_power"
],
"type": "field"
},
{
"params": [],
"type": "integral"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
},
{
"alias": "From Powerwall",
"groupBy": [],
"measurement": "http",
"orderByTime": "ASC",
"policy": "autogen",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"from_pw"
],
"type": "field"
},
{
"params": [],
"type": "integral"
},
{
"params": [
" / 1000 / 3600"
],
"type": "math"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
},
{
"alias": "From Grid",
"groupBy": [],
"measurement": "http",
"orderByTime": "ASC",
"policy": "autogen",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"from_grid"
],
"type": "field"
},
{
"params": [],
"type": "integral"
},
{
"params": [
" / 1000 / 3600"
],
"type": "math"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
}
],
"timeFrom": null,
"timeShift": null,
"title": "Power Flow",
"transparent": true,
"type": "text"
},
{
"alert": {
"alertRuleTags": {},
"conditions": [
{
"evaluator": {
"params": [
1
],
"type": "lt"
},
"operator": {
"type": "and"
},
"query": {
"params": [
"A",
"10s",
"now"
]
},
"reducer": {
"params": [],
"type": "avg"
},
"type": "query"
}
],
"executionErrorState": "alerting",
"for": "1m",
"frequency": "1m",
"handler": 1,
"message": "Grid Offline",
"name": "Grid Status alert",
"noDataState": "no_data",
"notifications": []
},
"aliasColors": {
"Home Usage": "blue"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"decimals": 0,
"description": "",
"fill": 0,
"fillGradient": 2,
"gridPos": {
"h": 3,
"w": 6,
"x": 17,
"y": 10
},
"hiddenSeries": false,
"hideTimeOverride": false,
"id": 53,
"interval": "",
"legend": {
"alignAsTable": false,
"avg": false,
"current": false,
"hideEmpty": false,
"hideZero": false,
"max": false,
"min": false,
"rightSide": false,
"show": false,
"total": false,
"values": false
},
"lines": true,
"linewidth": 2,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [
{
"alias": "Grid Status",
"color": "#73BF69"
}
],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "Grid Status",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"0"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "raw",
"query": "SELECT min(\"grid_status\") FROM \"raw\".\"http\" WHERE $timeFilter GROUP BY time($__interval) tz('America/Los_Angeles')",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"grid_status"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
}
],
"thresholds": [
{
"colorMode": "critical",
"fill": true,
"line": true,
"op": "lt",
"value": 1,
"yaxis": "left"
}
],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Grid Status",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "none",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"collapsed": false,
"datasource": null,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 13
},
"id": 41,
"panels": [],
"title": "Power Meters",
"type": "row"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": true,
"colors": [
"#FADE2A",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"datasource": null,
"decimals": 1,
"format": "kwatth",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 2,
"w": 4,
"x": 0,
"y": 14
},
"id": 5,
"interval": "",
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [],
"limit": "",
"measurement": "http",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT integral(\"solar_instant_power\") / 1000 / 3600 FROM \"http\" WHERE $timeFilter",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"solar"
],
"type": "field"
},
{
"params": [],
"type": "integral"
},
{
"params": [
" / 1000 / 3600"
],
"type": "math"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
}
],
"thresholds": "",
"timeFrom": null,
"timeShift": null,
"title": "Solar Energy",
"transparent": true,
"type": "singlestat",
"valueFontSize": "70%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": true,
"colors": [
"#5794F2",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"datasource": null,
"decimals": 1,
"format": "kwatth",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 2,
"w": 4,
"x": 4,
"y": 14
},
"id": 4,
"interval": "",
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [],
"measurement": "http",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT integral(\"load_instant_power\") / 1000 / 3600 FROM \"http\" WHERE $timeFilter GROUP BY time(1h) tz('America/Los_Angeles')",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"home"
],
"type": "field"
},
{
"params": [],
"type": "integral"
},
{
"params": [
" / 1000 / 3600"
],
"type": "math"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
}
],
"thresholds": "",
"timeFrom": null,
"timeShift": null,
"title": "Home Usage",
"transparent": true,
"type": "singlestat",
"valueFontSize": "70%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorPostfix": false,
"colorPrefix": false,
"colorValue": true,
"colors": [
"#73BF69",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"datasource": null,
"decimals": 1,
"format": "kwatth",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 2,
"w": 4,
"x": 8,
"y": 14
},
"id": 8,
"interval": "",
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [],
"measurement": "http",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT integral(\"battery_instant_power\") / -1000 / 3600 FROM \"http\" WHERE (\"battery_instant_power\" <= 0) AND $timeFilter GROUP BY time(1h) tz('America/Los_Angeles')",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"to_pw"
],
"type": "field"
},
{
"params": [],
"type": "integral"
},
{
"params": [
" / 1000 / 3600"
],
"type": "math"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
}
],
"thresholds": "",
"timeFrom": null,
"timeShift": null,
"title": "To Powerwall",
"transparent": true,
"type": "singlestat",
"valueFontSize": "70%",
"valueMaps": [
{
"op": "=",
"text": "0.0 kWh",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": true,
"colors": [
"#73BF69",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"datasource": null,
"decimals": 1,
"format": "kwatth",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 2,
"w": 4,
"x": 12,
"y": 14
},
"id": 6,
"interval": "",
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [],
"measurement": "http",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT integral(\"battery_instant_power\") / 1000 / 3600 FROM \"http\" WHERE (\"battery_instant_power\" > 0) AND $timeFilter tz('America/Los_Angeles')",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"from_pw"
],
"type": "field"
},
{
"params": [],
"type": "integral"
},
{
"params": [
" / 1000 / 3600"
],
"type": "math"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
}
],
"thresholds": "",
"timeFrom": null,
"timeShift": null,
"title": "From Powerwall",
"transparent": true,
"type": "singlestat",
"valueFontSize": "70%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": true,
"colors": [
"#B877D9",
"rgba(237, 129, 40, 0.89)",
"#F2495C"
],
"datasource": null,
"decimals": 1,
"format": "kwatth",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 2,
"w": 4,
"x": 16,
"y": 14
},
"id": 7,
"interval": "",
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [],
"measurement": "http",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT integral(\"site_instant_power\",1m) / -1000 / 3600 * 60 FROM \"http\" WHERE (\"site_instant_power\" < 0) AND $timeFilter GROUP BY time(1h) tz('America/Los_Angeles')",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"to_grid"
],
"type": "field"
},
{
"params": [],
"type": "integral"
},
{
"params": [
" / 1000 / 3600"
],
"type": "math"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
}
],
"thresholds": "",
"timeFrom": null,
"timeShift": null,
"title": "To Grid",
"transparent": true,
"type": "singlestat",
"valueFontSize": "70%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "total"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": true,
"colors": [
"#B877D9",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"datasource": null,
"decimals": 1,
"format": "kwatth",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 2,
"w": 4,
"x": 20,
"y": 14
},
"id": 9,
"interval": "",
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": false,
"ymax": null,
"ymin": null
},
"tableColumn": "",
"targets": [
{
"groupBy": [],
"measurement": "http",
"orderByTime": "ASC",
"policy": "autogen",
"query": "SELECT integral(\"site_instant_power\", 1m) / 1000 / 3600 * 60 FROM \"http\" WHERE (\"site_instant_power\" > 0) AND $timeFilter",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"from_grid"
],
"type": "field"
},
{
"params": [],
"type": "integral"
},
{
"params": [
" / 1000 / 3600"
],
"type": "math"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
}
],
"thresholds": "",
"timeFrom": null,
"timeShift": null,
"title": "From Grid",
"transparent": true,
"type": "singlestat",
"valueFontSize": "70%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "total"
},
{
"collapsed": false,
"datasource": null,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 16
},
"id": 47,
"panels": [],
"title": "Savings",
"type": "row"
},
{
"aliasColors": {
"battery": "green",
"battery impact": "green",
"combined": "red",
"solar": "yellow",
"solar + battery": "red",
"solar > grid": "purple",
"solar > home": "yellow",
"solar only": "yellow",
"total": "blue"
},
"bars": true,
"cacheTimeout": null,
"dashLength": 10,
"dashes": false,
"datasource": null,
"decimals": 2,
"description": "Estimated Savings",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 5,
"w": 9,
"x": 0,
"y": 17
},
"hiddenSeries": false,
"hideTimeOverride": true,
"id": 45,
"interval": "",
"legend": {
"alignAsTable": true,
"avg": false,
"current": false,
"hideEmpty": false,
"hideZero": true,
"max": false,
"min": false,
"rightSide": true,
"show": true,
"sort": null,
"sortDesc": null,
"total": true,
"values": true
},
"lines": false,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pluginVersion": "6.5.1",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "powerwall > home",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT fp FROM (SELECT sum(\"from_pw\") * 0.19 AS fp FROM kwh.http WHERE $timeFilter tz('America/Los_Angeles'))\n",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"from_grid"
],
"type": "field"
}
]
],
"tags": []
},
{
"alias": "solar > home",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT s - (tp + tg) FROM (SELECT sum(\"solar\") * 0.19 AS s, sum(\"to_pw\") * 0.19 AS tp, sum(\"to_grid\") * 0.19 AS tg FROM kwh.http WHERE $timeFilter tz('America/Los_Angeles'))\n",
"rawQuery": true,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"solar_instant_power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"/ 1000 * 0.358"
],
"type": "math"
}
]
],
"tags": []
},
{
"alias": "solar > grid",
"groupBy": [],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "kwh",
"query": "SELECT tg FROM (SELECT sum(\"to_pw\") * 0.19 AS tp, sum(\"solar\") * 0.19 AS s, sum(\"to_grid\") * 0.19 AS tg FROM kwh.http WHERE $timeFilter tz('America/Los_Angeles'))\n",
"rawQuery": true,
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"from_pw"
],
"type": "field"
},
{
"params": [
" * 0.19"
],
"type": "math"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
},
{
"alias": "total",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT tg + (s - tp - tg ) + fp FROM (SELECT sum(\"to_pw\") * 0.19 AS tp, sum(\"solar\") * 0.19 AS s, sum(\"to_grid\") * 0.19 AS tg, sum(\"from_pw\") * 0.19 AS fp FROM kwh.http WHERE $timeFilter tz('America/Los_Angeles'))\n",
"rawQuery": true,
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"solar_instant_power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
},
{
"params": [
"/ 1000 * 0.358"
],
"type": "math"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Savings",
"tooltip": {
"shared": false,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "series",
"name": null,
"show": false,
"values": [
"total"
]
},
"yaxes": [
{
"decimals": 2,
"format": "currencyUSD",
"label": "",
"logBase": 1,
"max": null,
"min": "0",
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"aliasColors": {
"Battery": "#73BF69",
"Battery Usage": "#73BF69",
"From Grid": "#B877D9",
"From Powerwall": "#73BF69",
"From Solar": "#FADE2A",
"Grid": "#B877D9",
"Grid Usage": "#B877D9",
"Powerwall": "#73BF69",
"Powerwall Usage": "#73BF69",
"Solar": "#FADE2A",
"Solar Usage": "#FADE2A",
"Total Solar": "#FADE2A",
"Total Usage": "#5794F2"
},
"breakPoint": "50%",
"cacheTimeout": null,
"combine": {
"label": "Others",
"threshold": 0
},
"datasource": null,
"fontSize": "100%",
"format": "kwatth",
"gridPos": {
"h": 5,
"w": 8,
"x": 9,
"y": 17
},
"id": 43,
"interval": "",
"legend": {
"header": "Power",
"percentage": true,
"percentageDecimals": 1,
"show": true,
"sortDesc": true,
"values": true
},
"legendType": "Right side",
"links": [],
"maxDataPoints": 3,
"nullPointMode": "connected",
"options": {},
"pieType": "donut",
"pluginVersion": "6.5.1",
"strokeWidth": "1",
"targets": [
{
"alias": "From Solar",
"groupBy": [
{
"params": [
"1h"
],
"type": "time"
},
{
"params": [
"none"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "default",
"query": "SELECT (1+from_solar/abs(from_solar))*from_solar/2 FROM (SELECT integral(solar)/1000/3600 - integral(to_pw)/1000/3600 - integral(to_grid)/1000/3600 AS from_solar FROM autogen.http WHERE $timeFilter tz('America/Los_Angeles'))",
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"solar_5m_power"
],
"type": "field"
},
{
"params": [],
"type": "integral"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
},
{
"alias": "From Powerwall",
"groupBy": [],
"measurement": "http",
"orderByTime": "ASC",
"policy": "autogen",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"from_pw"
],
"type": "field"
},
{
"params": [],
"type": "integral"
},
{
"params": [
" / 1000 / 3600"
],
"type": "math"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
},
{
"alias": "From Grid",
"groupBy": [],
"measurement": "http",
"orderByTime": "ASC",
"policy": "autogen",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"from_grid"
],
"type": "field"
},
{
"params": [],
"type": "integral"
},
{
"params": [
" / 1000 / 3600"
],
"type": "math"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
}
],
"timeFrom": null,
"timeShift": null,
"title": "Self-Powered",
"transparent": true,
"type": "grafana-piechart-panel",
"valueName": "total"
},
{
"activePatternIndex": 1,
"datasource": null,
"defaultPattern": {
"bgColors": "green|gray|red",
"bgColors_overrides": "0->green|2->red|1->yellow",
"clickable_cells_link": "",
"col_name": "Value",
"decimals": "2",
"defaultBGColor": "#5794F2",
"defaultTextColor": "black",
"delimiter": ".",
"displayTemplate": "_value_",
"enable_bgColor": false,
"enable_bgColor_overrides": false,
"enable_clickable_cells": false,
"enable_textColor": false,
"enable_textColor_overrides": false,
"enable_time_based_thresholds": false,
"enable_transform": true,
"enable_transform_overrides": false,
"filter": {
"value_above": "",
"value_below": ""
},
"format": "kwatt",
"name": "Default Pattern",
"null_color": "darkred",
"null_textcolor": "black",
"null_value": "No data",
"pattern": "*",
"row_col_wrapper": "_",
"row_name": "_1_",
"textColors": "red|orange|green",
"textColors_overrides": "0->red|2->green|1->yellow",
"thresholds": "0",
"time_based_thresholds": [],
"tooltipTemplate": "Series : _series_ <br/>Row Name : _row_name_ <br/>Col Name : _col_name_ <br/>Value : _value_",
"transform_values": "No Usage | Using <div style=\"float: right;\">_value_</div>",
"transform_values_overrides": "0->down|1->up",
"valueName": "current"
},
"default_title_for_rows": "Metric",
"font_size": ".9rem",
"gridPos": {
"h": 5,
"w": 6,
"x": 18,
"y": 17
},
"hide_first_column": false,
"hide_headers": true,
"id": 49,
"interval": "",
"options": {},
"patterns": [
{
"bgColors": "#B877D9 | gray | #F2495C",
"bgColors_overrides": "0->green|2->red|1->yellow",
"clickable_cells_link": "",
"col_name": "Value",
"decimals": "2",
"defaultBGColor": "",
"defaultTextColor": "",
"delimiter": ".",
"displayTemplate": "_value_",
"enable_bgColor": true,
"enable_bgColor_overrides": false,
"enable_clickable_cells": false,
"enable_textColor": true,
"enable_textColor_overrides": false,
"enable_time_based_thresholds": false,
"enable_transform": true,
"enable_transform_overrides": false,
"filter": {
"value_above": "",
"value_below": ""
},
"format": "kwatt",
"name": "Grid",
"null_color": "darkred",
"null_textcolor": "black",
"null_value": "No data",
"pattern": "http.Grid",
"row_col_wrapper": "_",
"row_name": "_1_",
"textColors": "white | white | white",
"textColors_overrides": "0->red|2->green|1->yellow",
"thresholds": "-0.09,0.09",
"time_based_thresholds": [],
"tooltipTemplate": "Series : _series_ <br/>Row Name : _row_name_ <br/>Col Name : _col_name_ <br/>Value : _value_",
"transform_values": "Exporting <div style=\"float: right;\">_value_</div> | Idle | Importing <div style=\"float: right;\">_value_</div>",
"transform_values_overrides": "0->down|1->up",
"valueName": "avg"
},
{
"bgColors": "#73BF69 | gray | #F2495C",
"bgColors_overrides": "0->green|2->red|1->yellow",
"clickable_cells_link": "",
"col_name": "Value",
"decimals": "2",
"defaultBGColor": "",
"defaultTextColor": "",
"delimiter": ".",
"displayTemplate": "_value_",
"enable_bgColor": true,
"enable_bgColor_overrides": false,
"enable_clickable_cells": false,
"enable_textColor": true,
"enable_textColor_overrides": false,
"enable_time_based_thresholds": false,
"enable_transform": true,
"enable_transform_overrides": false,
"filter": {
"value_above": "",
"value_below": ""
},
"format": "kwatt",
"name": "Battery",
"null_color": "darkred",
"null_textcolor": "black",
"null_value": "No data",
"pattern": "http.Battery",
"row_col_wrapper": "_",
"row_name": "_1_",
"textColors": "white | white | white",
"textColors_overrides": "0->red|2->green|1->yellow",
"thresholds": "-0.1,0.1",
"time_based_thresholds": [],
"tooltipTemplate": "Series : _series_ <br/>Row Name : _row_name_ <br/>Col Name : _col_name_ <br/>Value : _value_",
"transform_values": "Charging <div style=\"float: right;\">_value_</div> | Idle | Discharging <div style=\"float: right;\">_value_</div>",
"transform_values_overrides": "0->down|1->up",
"valueName": "avg"
},
{
"bgColors": "red|yellow",
"bgColors_overrides": "0->green|2->red|1->yellow",
"clickable_cells_link": "",
"col_name": "Value",
"decimals": "2",
"defaultBGColor": "#FADE2A",
"defaultTextColor": "black",
"delimiter": ".",
"displayTemplate": "_value_",
"enable_bgColor": false,
"enable_bgColor_overrides": false,
"enable_clickable_cells": false,
"enable_textColor": false,
"enable_textColor_overrides": false,
"enable_time_based_thresholds": false,
"enable_transform": true,
"enable_transform_overrides": false,
"filter": {
"value_above": "",
"value_below": ""
},
"format": "kwatt",
"name": "Solar",
"null_color": "darkred",
"null_textcolor": "black",
"null_value": "No data",
"pattern": "http.Solar",
"row_col_wrapper": "_",
"row_name": "_1_",
"textColors": "white|black",
"textColors_overrides": "0->red|2->green|1->yellow",
"thresholds": "0.1",
"time_based_thresholds": [],
"tooltipTemplate": "Series : _series_ <br/>Row Name : _row_name_ <br/>Col Name : _col_name_ <br/>Value : _value_",
"transform_values": "No Generation | Generating <div style=\"float: right;\">_value_</div>",
"transform_values_overrides": "0->down|1->up",
"valueName": "avg"
}
],
"row_col_wrapper": "_",
"sorting_props": {
"col_index": -1,
"direction": "desc"
},
"targets": [
{
"groupBy": [],
"measurement": "http",
"orderByTime": "ASC",
"policy": "raw",
"query": "SELECT last(\"load_instant_power\") / 1000 AS \"Home\", last(\"solar_instant_power\") / 1000 AS \"Solar\", last(\"battery_instant_power\") / 1000 AS \"Battery\", last(\"site_instant_power\") / 1000 AS \"Grid\" FROM \"raw\".\"http\" WHERE $timeFilter",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"load_instant_power"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
" / 1000"
],
"type": "math"
},
{
"params": [
"Home"
],
"type": "alias"
}
],
[
{
"params": [
"solar_instant_power"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
" / 1000"
],
"type": "math"
},
{
"params": [
"Solar"
],
"type": "alias"
}
],
[
{
"params": [
"battery_instant_power"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
" / 1000"
],
"type": "math"
},
{
"params": [
"Battery"
],
"type": "alias"
}
],
[
{
"params": [
"site_instant_power"
],
"type": "field"
},
{
"params": [],
"type": "last"
},
{
"params": [
" / 1000"
],
"type": "math"
},
{
"params": [
"Grid"
],
"type": "alias"
}
]
],
"tags": []
}
],
"timeFrom": null,
"timeShift": null,
"title": "Current State",
"transparent": true,
"type": "yesoreyeram-boomtable-panel"
},
{
"collapsed": false,
"datasource": null,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 22
},
"id": 22,
"panels": [],
"title": "Monthly Analysis",
"type": "row"
},
{
"aliasColors": {
"Home Usage": "blue"
},
"bars": true,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 23
},
"hiddenSeries": false,
"id": 24,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": false,
"total": false,
"values": false
},
"lines": false,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "Home Usage",
"groupBy": [
{
"params": [
"1d"
],
"type": "time"
},
{
"params": [
"0"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "kwh",
"query": "SELECT sum(\"home\") FROM \"kwh\".\"http\" WHERE $timeFilter GROUP BY time(1d) fill(0) tz('America/Los_Angeles')",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"home"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
}
],
"thresholds": [],
"timeFrom": "1M",
"timeRegions": [],
"timeShift": null,
"title": "Home Usage",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "kwatth",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"aliasColors": {
"Solar Energy": "yellow"
},
"bars": true,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 23
},
"hiddenSeries": false,
"id": 25,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": false,
"total": false,
"values": false
},
"lines": false,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "Solar Energy",
"groupBy": [
{
"params": [
"1d"
],
"type": "time"
},
{
"params": [
"0"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "kwh",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"solar"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": [
{
"key": "solar",
"operator": ">",
"value": "0"
}
],
"tz": "America/Los_Angeles"
}
],
"thresholds": [],
"timeFrom": "1M",
"timeRegions": [],
"timeShift": null,
"title": "Solar Energy",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "kwatth",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"aliasColors": {
"From Powerwall": "green"
},
"bars": true,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 31
},
"hiddenSeries": false,
"id": 26,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": false,
"total": false,
"values": false
},
"lines": false,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "From Powerwall",
"groupBy": [
{
"params": [
"1d"
],
"type": "time"
},
{
"params": [
"0"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "kwh",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"from_pw"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
}
],
"thresholds": [],
"timeFrom": "1M",
"timeRegions": [],
"timeShift": null,
"title": "From Powerwall",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "kwatth",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"aliasColors": {
"From Grid": "red",
"To Grid": "purple",
"http.From Grid": "red",
"http.To Grid": "purple"
},
"bars": true,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 31
},
"hiddenSeries": false,
"id": 27,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": false,
"total": false,
"values": false
},
"lines": false,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [
{
"alias": "http.From Grid"
}
],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "From Grid",
"groupBy": [
{
"params": [
"1d"
],
"type": "time"
},
{
"params": [
"0"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "kwh",
"query": "SELECT sum(\"from_grid\") FROM \"daily\".\"http\" WHERE $timeFilter GROUP BY time(1d) fill(0) tz('America/Los_Angeles')",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"from_grid"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
},
{
"alias": "To Grid",
"groupBy": [
{
"params": [
"1d"
],
"type": "time"
},
{
"params": [
"0"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "kwh",
"query": "SELECT sum(\"to_grid\") * -1 FROM \"daily\".\"http\" WHERE $timeFilter GROUP BY time(1d) fill(0) tz('America/Los_Angeles')",
"rawQuery": false,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"to_grid"
],
"type": "field"
},
{
"params": [],
"type": "sum"
},
{
"params": [
" * -1"
],
"type": "math"
}
]
],
"tags": [],
"tz": "America/Los_Angeles"
}
],
"thresholds": [],
"timeFrom": "1M",
"timeRegions": [],
"timeShift": null,
"title": "Grid Usage",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "kwatth",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"aliasColors": {
"Solar Energy": "yellow"
},
"bars": true,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 5,
"w": 24,
"x": 0,
"y": 39
},
"hiddenSeries": false,
"id": 30,
"interval": "",
"legend": {
"alignAsTable": false,
"avg": false,
"current": false,
"max": false,
"min": false,
"show": false,
"total": false,
"values": false
},
"lines": false,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [
{
"alias": "Solar Energy Year",
"color": "#FADE2A"
}
],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "Solar Energy Year",
"groupBy": [
{
"params": [
"1d"
],
"type": "time"
},
{
"params": [
"0"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "kwh",
"query": "SELECT sum(\"solar\") FROM \"kwh\".\"http\" WHERE (\"solar\" > 0) AND $timeFilter GROUP BY time(1d) fill(0) tz('America/Los_Angeles')",
"rawQuery": false,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"solar"
],
"type": "field"
},
{
"params": [],
"type": "sum"
}
]
],
"tags": [
{
"key": "solar",
"operator": ">",
"value": "0"
}
],
"tz": "America/Los_Angeles"
}
],
"thresholds": [],
"timeFrom": "12M",
"timeRegions": [],
"timeShift": null,
"title": "Solar Energy Year",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "kwatth",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"collapsed": false,
"datasource": null,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 44
},
"id": 37,
"panels": [],
"title": "Powerwall+",
"type": "row"
},
{
"aliasColors": {
"Solar Energy": "yellow"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fill": 0,
"fillGradient": 0,
"gridPos": {
"h": 5,
"w": 8,
"x": 0,
"y": 45
},
"hiddenSeries": false,
"id": 32,
"interval": "",
"legend": {
"avg": false,
"current": false,
"hideEmpty": false,
"hideZero": false,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "A",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"A_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "B",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"B_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "C",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"C_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "D",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"D_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "A1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"A1_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "B1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "F",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"B1_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "C1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "G",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"C1_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "D1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "H",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"D1_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "A2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "I",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"A2_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "B2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "J",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"B2_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "C2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "K",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"C2_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "D2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "L",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"D2_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "A3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "M",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"A3_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "B3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "N",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"B3_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "C3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "O",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"C3_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "D3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "P",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"D3_Voltage"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "String Voltage",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "volt",
"label": null,
"logBase": 1,
"max": null,
"min": "0",
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"aliasColors": {
"Solar Energy": "yellow"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fill": 0,
"fillGradient": 0,
"gridPos": {
"h": 5,
"w": 8,
"x": 8,
"y": 45
},
"hiddenSeries": false,
"id": 33,
"interval": "",
"legend": {
"avg": false,
"current": false,
"hideEmpty": false,
"hideZero": false,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "A",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"A_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "B",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"B_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "C",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"C_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "D",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"D_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "A1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"A1_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "B1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "F",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"B1_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "C1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "G",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"C1_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "D1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "H",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"D1_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "A2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "I",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"A2_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "B2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "J",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"B2_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "C2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "K",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"C2_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "D2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "L",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"D2_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "A3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "M",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"A3_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "B3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "N",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"B3_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "C3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "O",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"C3_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "D3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "P",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"D3_Current"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "String Current",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "amp",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"aliasColors": {
"Solar Energy": "yellow"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fill": 0,
"fillGradient": 0,
"gridPos": {
"h": 5,
"w": 8,
"x": 16,
"y": 45
},
"hiddenSeries": false,
"id": 31,
"interval": "",
"legend": {
"avg": false,
"current": false,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "A",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"A_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "B",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"B_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "C",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"C_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "D",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"D_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "A1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"A1_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "B1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "F",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"B1_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "C1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "G",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"C1_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "D1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "H",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"D1_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "A2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "I",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"A2_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "B2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "J",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"B2_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "C2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "K",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"C2_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "D2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "L",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"D2_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "A3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "M",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"A3_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "B3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "N",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"B3_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "C3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "O",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"C3_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "D3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": false,
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "P",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"D3_Power"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "String Power",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "watt",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"aliasColors": {
"Solar Energy": "yellow"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"fill": 0,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 12,
"x": 0,
"y": 50
},
"hiddenSeries": false,
"id": 34,
"interval": "",
"legend": {
"avg": false,
"current": false,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "Inverter1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Inverter1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Inverter2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Inverter2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Inverter3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Inverter3"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Inverter4",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "strings",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"Inverter4"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Inverter Power",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"decimals": null,
"format": "watt",
"label": null,
"logBase": 1,
"max": null,
"min": "0",
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"aliasColors": {
"Solar Energy": "yellow"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"decimals": 1,
"fill": 0,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 12,
"x": 12,
"y": 50
},
"hiddenSeries": false,
"id": 35,
"interval": "",
"legend": {
"avg": false,
"current": false,
"max": true,
"min": true,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "Powerwall1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "pwtemps",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW1_temp"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Powerwall2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "pwtemps",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW2_temp"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Powerwall3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "pwtemps",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW3_temp"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Powerwall4",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "pwtemps",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW4_temp"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Powerwall5",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "pwtemps",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW5_temp"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Powerwall6",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "pwtemps",
"refId": "F",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW6_temp"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Powerwall Temps ",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"format": "celsius",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"aliasColors": {
"Solar Energy": "yellow"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"decimals": 1,
"description": "",
"fill": 0,
"fillGradient": 0,
"gridPos": {
"h": 5,
"w": 24,
"x": 0,
"y": 56
},
"hiddenSeries": false,
"id": 38,
"interval": "",
"legend": {
"avg": false,
"current": false,
"hideEmpty": false,
"hideZero": false,
"max": true,
"min": true,
"rightSide": true,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "Home L1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ISLAND_FreqL1_Load"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Home L2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ISLAND_FreqL2_Load"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Home L3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": true,
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "G",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ISLAND_FreqL3_Load"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Grid L1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ISLAND_FreqL1_Main"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Grid L2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "F",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ISLAND_FreqL2_Main"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Grid L3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": true,
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "H",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ISLAND_FreqL3_Main"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW1_PINV_Fout"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW2_PINV_Fout"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "I",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW3_PINV_Fout"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW4",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "J",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW4_PINV_Fout"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW5",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "K",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW5_PINV_Fout"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW6",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "L",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW6_PINV_Fout"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Frequency",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"decimals": null,
"format": "hertz",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"aliasColors": {
"Solar Energy": "yellow"
},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": null,
"decimals": 1,
"description": "",
"fill": 0,
"fillGradient": 0,
"gridPos": {
"h": 5,
"w": 24,
"x": 0,
"y": 61
},
"hiddenSeries": false,
"id": 39,
"interval": "",
"legend": {
"avg": false,
"current": false,
"hideEmpty": false,
"hideZero": false,
"max": true,
"min": true,
"rightSide": true,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"dataLinks": []
},
"percentage": false,
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"alias": "Home L1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ISLAND_VL1N_Load"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Home L2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "E",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ISLAND_VL2N_Load"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Home L3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": true,
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "G",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"ISLAND_VL3N_Load"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Grid L1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"METER_X_VL1N"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Grid L2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "F",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"METER_X_VL2N"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Grid L3",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"hide": true,
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "H",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"METER_X_VL3N"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW1 L1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW1_PINV_VSplit1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW1 L2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "M",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW1_PINV_VSplit2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW2 L1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW2_PINV_VSplit1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW2 L2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"refId": "I",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW2_PINV_VSplit2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW3 L1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"query": "SELECT mean(\"PW3_PINV_VSplit1\") FROM \"vitals\".\"http\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "J",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW3_PINV_VSplit1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW3 L2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"query": "SELECT mean(\"PW3_PINV_VSplit2\") FROM \"vitals\".\"http\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "K",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW3_PINV_VSplit2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW4 L1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"query": "SELECT mean(\"PW4_PINV_VSplit1\") FROM \"vitals\".\"http\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "L",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW4_PINV_VSplit1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW4 L2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"query": "SELECT mean(\"PW4_PINV_VSplit2\") FROM \"vitals\".\"http\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "N",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW4_PINV_VSplit2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW5 L1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"query": "SELECT mean(\"PW5_PINV_VSplit1\") FROM \"vitals\".\"http\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "O",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW5_PINV_VSplit1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW5 L2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"query": "SELECT mean(\"PW5_PINV_VSplit2\") FROM \"vitals\".\"http\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "P",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW5_PINV_VSplit2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW6 L1",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"query": "SELECT mean(\"PW6_PINV_VSplit1\") FROM \"vitals\".\"http\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "Q",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW6_PINV_VSplit1"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "PW6 L2",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"query": "SELECT mean(\"PW6_PINV_VSplit2\") FROM \"vitals\".\"http\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "R",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"PW6_PINV_VSplit2"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Grid L1 SW",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"query": "SELECT mean(\"METER_Z_VL1G\") FROM \"vitals\".\"http\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "S",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"METER_Z_VL1G"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
},
{
"alias": "Grid L2 SW",
"groupBy": [
{
"params": [
"$__interval"
],
"type": "time"
},
{
"params": [
"null"
],
"type": "fill"
}
],
"measurement": "http",
"orderByTime": "ASC",
"policy": "vitals",
"query": "SELECT mean(\"METER_Z_VL2G\") FROM \"vitals\".\"http\" WHERE $timeFilter GROUP BY time($__interval) fill(null)",
"rawQuery": false,
"refId": "T",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"METER_Z_VL2G"
],
"type": "field"
},
{
"params": [],
"type": "mean"
}
]
],
"tags": []
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
"title": "Voltages",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"transparent": true,
"type": "graph",
"xaxis": {
"buckets": null,
"mode": "time",
"name": null,
"show": true,
"values": []
},
"yaxes": [
{
"decimals": null,
"format": "volt",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": true
},
{
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
"show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
}
],
"refresh": "5m",
"schemaVersion": 21,
"style": "dark",
"tags": [],
"templating": {
"list": []
},
"time": {
"from": "now-24h",
"to": "now"
},
"timepicker": {
"refresh_intervals": [
"5s",
"10s",
"30s",
"1m",
"5m",
"15m",
"30m",
"1h",
"2h",
"1d"
]
},
"timezone": "browser",
"title": "Powerwall Power Flow",
"uid": "RSabAvRRz",
"version": 9
} |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
This is pretty cool. I have just updated everything on my system to current using the upgrade.sh script. I am seeing the powerflow animation, but my grid status shows "No Data". Do I need to change something in InfluxDB? |
Beta Was this translation helpful? Give feedback.
10 replies
-
|
The powerwall capacity is very useful. I used to pull the data from the API monthly on the 16th to monitor capacity change over time. Great work!!! |
Beta Was this translation helpful? Give feedback.
-
|
Thanks @oralallen82 ! I appreciate the feedback. I don't know why I didn't add this sooner. I confess, however, it does give me some anxiety to see the battery capacity fall off so fast at times. You can see it when you zoom in on just the capacity metrics (e.g. click on PW1). I mean, that is what batteries do, especially with heavy load cycles, but still was a bit concerning. 🤷 Regardless, I love having the data.
|
Beta Was this translation helpful? Give feedback.
-
Viewing it daily will give you anxiety but monthly it's within spec. Here's mine that I extrapolated from the API: <style type="text/css"></style>
|
Beta Was this translation helpful? Give feedback.
-
|
Thanks @oralallen82 ! There is some interesting in calculating the "battery life" (see #39). I wonder if there would be interesting in adding a parallel plot of "in spec" degradation on this same graph? It may allow you to see if you are staying on track with what is expected. |
Beta Was this translation helpful? Give feedback.
-
|
That would be very useful. I track overall Capacity of my 3 powerwalls individual would be beneficial. |
Beta Was this translation helpful? Give feedback.
-
|
|
Beta Was this translation helpful? Give feedback.
5 replies
-
|
Hi @jasonacox - I finally got Postfix setup in my VM running the dashboard. I am having trouble with how I get Grafana to be able to use the relay. Where is the grafana.ini file that I need to edit, and will the edit survive an update? I wanted to get the grid status alert working. |
Beta Was this translation helpful? Give feedback.
-
|
Great question @cwagz - To get it to use an SMTP relay you will set the environment variables in the GF_SMTP_ENABLED: "true"
GF_SMTP_HOST: "smtp.example.com"
GF_SMTP_USER: "myuser"
GF_SMTP_PASSWORD: "mysecret"To pull in those changes, you would run: docker-compose -f powerwall.yml up -dAs you likely suspect, that will break the |
Beta Was this translation helpful? Give feedback.
-
|
Ok - Getting the Docker container to communicate with the host Postfix relay was too difficult for me to figure out. I kept getting connection refused even after updating the Postfix config to listen on the docker0 interface. It was much easier to just get Grafana to relay directly through outlook.com I also took the time to figure out how to inject SSL certs from my CA into Grafana and turn on HTTPS. This might pose a problem with Here is what I have working: When the container is rebuilt, it copies the key files that I placed in the Grafana folder to the docker container. Could I just create a key folder in my home directory and set the environment variables so the install script would copy the files prior to running docker compose? |
Beta Was this translation helpful? Give feedback.
-
|
Nice! Good work. There is a simple way to externalize the environmental variables (which is what pypowerwall uses) that we could do for Grafana. The |
Beta Was this translation helpful? Give feedback.
-
|
Ok, with release 2.4.3 I have externalized the Grafana settings in the grafana.env file that is created (if not existing) during setup.sh or upgrade.sh. For anyone following this, you may want (need) to backup and |
Beta Was this translation helpful? Give feedback.
-
|
@jasonacox @cwagz This thread inspired me to create an alert in Grafana that could notify my Apple Home environment when the grid goes down. Using Homebridge you can integrate all sorts of things into Apple Home. I was already using a plugin that connects to Tesla Powerwall's, but I have observed that it occasionally loses connection to Powerwall and wrongly triggers a grid-down state... and I have automations that act on grid-down to power off some devices, and not power up some unnecessary devices (I don't really need warm bath towels if the grid is down, but if it is a false alarm then I miss the warm towels in the morning). So I have replaced that plugin... Grafana lets you setup a contact point that uses webhook. Homebridge has a plugin that will let you "turn on" or "turn off" a switch from a URL request, I used this one. And set it up to respond to Then I created two alert rules in Grafana that watch I can then use all sorts of automations in Apple Home to respond to the grid going down, and coming back up. I am expecting this to be more reliable than the current plugin I am using (why? Not sure really, but I observed a false grid-down the other night which pyPowerwall did not observe. So I think the pyPowerwall proxy must have a more stable connection to the powerwalls). Really, really, cool. David |
Beta Was this translation helpful? Give feedback.
3 replies
-
|
Great job @dkerr64 ! I love this! Can you share the rules you created (export and/or screenshot)? |
Beta Was this translation helpful? Give feedback.
-
|
I cannot see a way to export the alert rules so just went with screen shots. I am showing the grid-up alert settings. For grid-down it is all pretty much the same except I test for I have to say that the Grafana alerts system feels awfully complex. It may be powerful, but it was not easy to figure out and setup. Their documentation feels somewhat lacking. David.
|
Beta Was this translation helpful? Give feedback.
-
|
This is great! Thanks @dkerr64 , I'm setting this up now. 👍 Also, I found a way to export Alerts (to see all settings): http://localhost:9000/api/prometheus/grafana/api/v1/rules (use a browser that is already logged in to Grafana so it has the token cookie or disable login). However, may not be helpful as I don't see an easy way to import using that. Your screenshots are helpful. |
Beta Was this translation helpful? Give feedback.
-
|
Thank you @dkerr64 for your suggestions and detailed instructions and screenshots. I too use homebridge on my Mac-based home. I was able to set up your alerts and virtual switch. I then bought a Matter nightlight THIRDREALITY Smart Color Night Light and set up and automation to turn the nightlight red when the grid goes down and green when it's up. Sweet.
|
Beta Was this translation helpful? Give feedback.
1 reply
-
|
Nice!! |
Beta Was this translation helpful? Give feedback.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I'm thinking about adding a panel in the dashboard to show grid status over time. Alerting could be added. I show a test below (this is an actual grid power outage we had). Would this be useful?
Currently, the raw data is in InfluxDB to build the above graph, but is not being downsampled (preserved) for longer term analysis. Grafana Panel JSON for anyone wanting to try it:
Panel JSON for Grid Status
{ "datasource": null, "alert": { "alertRuleTags": {}, "conditions": [ { "evaluator": { "params": [ 1 ], "type": "lt" }, "operator": { "type": "and" }, "query": { "params": [ "A", "5m", "now" ] }, "reducer": { "params": [], "type": "avg" }, "type": "query" } ], "executionErrorState": "alerting", "for": "5m", "frequency": "1m", "handler": 1, "message": "Grid Offline", "name": "Grid Status alert", "noDataState": "no_data", "notifications": [] }, "aliasColors": { "Home Usage": "blue" }, "bars": false, "dashLength": 10, "dashes": false, "decimals": 0, "description": "", "fill": 0, "fillGradient": 0, "gridPos": { "h": 5, "w": 11, "x": 13, "y": 66 }, "hiddenSeries": false, "hideTimeOverride": false, "id": 41, "interval": "", "legend": { "alignAsTable": false, "avg": false, "current": false, "hideEmpty": false, "hideZero": false, "max": false, "min": false, "rightSide": true, "show": true, "total": false, "values": false }, "lines": true, "linewidth": 4, "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "alias": "Grid Status", "groupBy": [ { "params": [ "$__interval" ], "type": "time" }, { "params": [ "0" ], "type": "fill" } ], "measurement": "http", "orderByTime": "ASC", "policy": "raw", "query": "SELECT min(\"grid_status\") FROM \"raw\".\"http\" WHERE $timeFilter GROUP BY time($__interval) tz('America/Los_Angeles')", "rawQuery": true, "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "grid_status" ], "type": "field" }, { "params": [], "type": "sum" } ] ], "tags": [], "tz": "America/Los_Angeles" } ], "thresholds": [ { "colorMode": "critical", "fill": true, "line": true, "op": "lt", "value": 1, "yaxis": "left" } ], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "Grid Status", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "transparent": true, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "none", "label": null, "logBase": 1, "max": null, "min": null, "show": false }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": false } ], "yaxis": { "align": false, "alignLevel": null } }Beta Was this translation helpful? Give feedback.
All reactions