Created
June 8, 2022 04:15
-
-
Save jonchen727/b0e42be08d7f1c4be1a93ebddab363cd to your computer and use it in GitHub Desktop.
Grafana Dashboard for Enphase Envoy Monitoring
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "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": 13, | |
| "links": [], | |
| "panels": [ | |
| { | |
| "collapsed": false, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 0 | |
| }, | |
| "id": 17, | |
| "panels": [], | |
| "title": "Overview", | |
| "type": "row" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": { | |
| "decimals": 1, | |
| "mappings": [], | |
| "max": 8900, | |
| "min": 0, | |
| "thresholds": { | |
| "mode": "percentage", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "watt" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 6, | |
| "x": 0, | |
| "y": 1 | |
| }, | |
| "id": 7, | |
| "interval": null, | |
| "links": [], | |
| "maxDataPoints": 100, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "text": {}, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "7.5.10", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "previous" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "production_1_wNow" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Current Output", | |
| "type": "stat" | |
| }, | |
| { | |
| "blendName": "total", | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorPostfix": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "#F2495C", | |
| "#73BF69", | |
| "#F2495C" | |
| ], | |
| "datasource": "Envoy", | |
| "decimals": 0, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "format": "volt", | |
| "gauge": { | |
| "maxValue": 245, | |
| "minValue": 225, | |
| "show": true, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 3, | |
| "x": 6, | |
| "y": 1 | |
| }, | |
| "id": 8, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "pluginVersion": "7.0.5", | |
| "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": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "production_1_rmsVoltage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": "230,240", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "RMS Voltage", | |
| "type": "farski-blendstat-panel", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "blendName": "total", | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorPostfix": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "#73BF69", | |
| "#FADE2A", | |
| "#F2495C" | |
| ], | |
| "datasource": "Envoy", | |
| "decimals": 1, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "format": "amp", | |
| "gauge": { | |
| "maxValue": 42, | |
| "minValue": 0, | |
| "show": true, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 3, | |
| "x": 9, | |
| "y": 1 | |
| }, | |
| "id": 9, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "pluginVersion": "7.0.5", | |
| "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": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT (last(\"production_1_rmsCurrent\") -4.3)/2 FROM \"http\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", | |
| "rawQuery": false, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "production_1_rmsCurrent" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| }, | |
| { | |
| "params": [ | |
| "/2" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": "35,40", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "RMS Current", | |
| "type": "farski-blendstat-panel", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "blendName": "total", | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": false, | |
| "colors": [ | |
| "#299c46", | |
| "rgba(237, 129, 40, 0.89)", | |
| "#d44a3a" | |
| ], | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "format": "watth", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 2, | |
| "w": 4, | |
| "x": 12, | |
| "y": 1 | |
| }, | |
| "id": 10, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "pluginVersion": "7.0.5", | |
| "postfix": "", | |
| "postfixFontSize": "100%", | |
| "prefix": "", | |
| "prefixFontSize": "100%", | |
| "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 | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "production_1_whLastSevenDays" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": "", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "7 Day Generation", | |
| "type": "farski-blendstat-panel", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": { | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "currencyUSD" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 8, | |
| "x": 16, | |
| "y": 1 | |
| }, | |
| "id": 22, | |
| "interval": null, | |
| "links": [], | |
| "maxDataPoints": 100, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "text": {}, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "7.5.10", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "production_1_whLifetime" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| }, | |
| { | |
| "params": [ | |
| "*0.00028" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Lifetime Savings", | |
| "type": "stat" | |
| }, | |
| { | |
| "blendName": "total", | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": false, | |
| "colors": [ | |
| "#299c46", | |
| "rgba(237, 129, 40, 0.89)", | |
| "#d44a3a" | |
| ], | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "format": "watth", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 4, | |
| "x": 12, | |
| "y": 3 | |
| }, | |
| "id": 6, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "pluginVersion": "7.0.5", | |
| "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": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "production_1_whToday" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": "", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Power Generated Today", | |
| "type": "farski-blendstat-panel", | |
| "valueFontSize": "100%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": { | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 6, | |
| "x": 6, | |
| "y": 5 | |
| }, | |
| "id": 21, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "last" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "text": {}, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "7.5.10", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "previous" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "production_1_pwrFactor" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Power Factor", | |
| "type": "stat" | |
| }, | |
| { | |
| "blendName": "total", | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": false, | |
| "colors": [ | |
| "#299c46", | |
| "rgba(237, 129, 40, 0.89)", | |
| "#d44a3a" | |
| ], | |
| "datasource": "Envoy", | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "format": "watth", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 2, | |
| "w": 4, | |
| "x": 12, | |
| "y": 7 | |
| }, | |
| "id": 11, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "pluginVersion": "7.0.5", | |
| "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 | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "production_1_whLifetime" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": "", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Lifetime Generation", | |
| "type": "farski-blendstat-panel", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "watt" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 6, | |
| "x": 0, | |
| "y": 9 | |
| }, | |
| "id": 29, | |
| "interval": null, | |
| "maxDataPoints": null, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "text": {}, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "7.5.10", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "previous" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "consumption_0_wNow" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Consumption", | |
| "type": "stat" | |
| }, | |
| { | |
| "blendName": "total", | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorPostfix": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "#F2495C", | |
| "#73BF69", | |
| "#F2495C" | |
| ], | |
| "datasource": "Envoy", | |
| "decimals": 0, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "format": "volt", | |
| "gauge": { | |
| "maxValue": 245, | |
| "minValue": 225, | |
| "show": true, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 3, | |
| "x": 6, | |
| "y": 9 | |
| }, | |
| "id": 34, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "pluginVersion": "7.0.5", | |
| "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": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "consumption_0_rmsVoltage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": "230,240", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "RMS Voltage", | |
| "type": "farski-blendstat-panel", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "blendName": "total", | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorPostfix": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "#73BF69", | |
| "#FADE2A", | |
| "#F2495C" | |
| ], | |
| "datasource": "Envoy", | |
| "decimals": 1, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "format": "amp", | |
| "gauge": { | |
| "maxValue": 205, | |
| "minValue": 0, | |
| "show": true, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 3, | |
| "x": 9, | |
| "y": 9 | |
| }, | |
| "id": 35, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "pluginVersion": "7.0.5", | |
| "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": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "consumption_0_rmsCurrent" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| }, | |
| { | |
| "params": [ | |
| "/2" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": "150,200", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "RMS Current", | |
| "type": "farski-blendstat-panel", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "blendName": "total", | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": false, | |
| "colors": [ | |
| "#299c46", | |
| "rgba(237, 129, 40, 0.89)", | |
| "#d44a3a" | |
| ], | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "format": "watth", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 2, | |
| "w": 4, | |
| "x": 12, | |
| "y": 9 | |
| }, | |
| "id": 40, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "pluginVersion": "7.0.5", | |
| "postfix": "", | |
| "postfixFontSize": "100%", | |
| "prefix": "", | |
| "prefixFontSize": "100%", | |
| "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 | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "consumption_0_whLastSevenDays" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": "", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "7 Day Consumption", | |
| "type": "farski-blendstat-panel", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "blendName": "total", | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": false, | |
| "colors": [ | |
| "#299c46", | |
| "rgba(237, 129, 40, 0.89)", | |
| "#d44a3a" | |
| ], | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "format": "watth", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 4, | |
| "x": 12, | |
| "y": 11 | |
| }, | |
| "id": 41, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "pluginVersion": "7.0.5", | |
| "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": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "consumption_0_whToday" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": "", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Power Consumed Today", | |
| "type": "farski-blendstat-panel", | |
| "valueFontSize": "100%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": { | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 6, | |
| "x": 6, | |
| "y": 13 | |
| }, | |
| "id": 36, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "last" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "text": {}, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "7.5.10", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "previous" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "consumption_0_pwrFactor" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Power Factor", | |
| "type": "stat" | |
| }, | |
| { | |
| "blendName": "total", | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": false, | |
| "colors": [ | |
| "#299c46", | |
| "rgba(237, 129, 40, 0.89)", | |
| "#d44a3a" | |
| ], | |
| "datasource": "Envoy", | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "format": "watth", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 2, | |
| "w": 4, | |
| "x": 12, | |
| "y": 15 | |
| }, | |
| "id": 42, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "pluginVersion": "7.0.5", | |
| "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 | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "consumption_0_whLifetime" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": "", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Lifetime Consumption", | |
| "type": "farski-blendstat-panel", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "watt" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 6, | |
| "x": 0, | |
| "y": 17 | |
| }, | |
| "id": 28, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "text": {}, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "7.5.10", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "previous" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "consumption_1_wNow" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Net Power", | |
| "type": "stat" | |
| }, | |
| { | |
| "blendName": "total", | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorPostfix": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "#F2495C", | |
| "#73BF69", | |
| "#F2495C" | |
| ], | |
| "datasource": "Envoy", | |
| "decimals": 0, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "format": "volt", | |
| "gauge": { | |
| "maxValue": 245, | |
| "minValue": 225, | |
| "show": true, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 3, | |
| "x": 6, | |
| "y": 17 | |
| }, | |
| "id": 37, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "pluginVersion": "7.0.5", | |
| "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": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "consumption_1_rmsVoltage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": "230,240", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "RMS Voltage", | |
| "type": "farski-blendstat-panel", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "blendName": "total", | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorPostfix": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "#73BF69", | |
| "#FADE2A", | |
| "#F2495C" | |
| ], | |
| "datasource": "Envoy", | |
| "decimals": 1, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "format": "amp", | |
| "gauge": { | |
| "maxValue": 205, | |
| "minValue": 0, | |
| "show": true, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 3, | |
| "x": 9, | |
| "y": 17 | |
| }, | |
| "id": 38, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "pluginVersion": "7.0.5", | |
| "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": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "consumption_1_rmsCurrent" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| }, | |
| { | |
| "params": [ | |
| "/2" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": "150,200", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "RMS Current", | |
| "type": "farski-blendstat-panel", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "blendName": "total", | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": false, | |
| "colors": [ | |
| "#299c46", | |
| "rgba(237, 129, 40, 0.89)", | |
| "#d44a3a" | |
| ], | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "format": "watth", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 4, | |
| "x": 12, | |
| "y": 17 | |
| }, | |
| "id": 43, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "pluginVersion": "7.0.5", | |
| "postfix": "", | |
| "postfixFontSize": "100%", | |
| "prefix": "", | |
| "prefixFontSize": "100%", | |
| "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 | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "previous" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT last(\"consumption_0_whLastSevenDays\")-last(\"production_1_whLastSevenDays\") FROM \"http\" WHERE $timeFilter GROUP BY time($__interval) fill(previous)", | |
| "rawQuery": true, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "consumption_0_whLastSevenDays" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": "", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "7 Day Net", | |
| "type": "farski-blendstat-panel", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": { | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 6, | |
| "x": 6, | |
| "y": 21 | |
| }, | |
| "id": 39, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "last" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "text": {}, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "7.5.10", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "previous" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "production_1_pwrFactor" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Power Factor", | |
| "type": "stat" | |
| }, | |
| { | |
| "blendName": "total", | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": false, | |
| "colors": [ | |
| "#299c46", | |
| "rgba(237, 129, 40, 0.89)", | |
| "#d44a3a" | |
| ], | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "format": "watth", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 4, | |
| "w": 4, | |
| "x": 12, | |
| "y": 21 | |
| }, | |
| "id": 44, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "pluginVersion": "7.0.5", | |
| "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": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT last(\"consumption_0_whToday\")-last(\"production_1_whToday\") FROM \"http\" WHERE $timeFilter GROUP BY time($__interval) fill(null)", | |
| "rawQuery": true, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "consumption_0_whToday" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": "", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Net Power Today", | |
| "type": "farski-blendstat-panel", | |
| "valueFontSize": "100%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": { | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 24, | |
| "x": 0, | |
| "y": 25 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 2, | |
| "legend": { | |
| "alignAsTable": false, | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "rightSide": false, | |
| "show": false, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.10", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "http.last", | |
| "color": "#5794F2" | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "Output", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": false, | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "production_1_wNow" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "alias": "Consumption", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": false, | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "B", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "consumption_0_wNow" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| }, | |
| { | |
| "alias": "Net", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": false, | |
| "measurement": "http", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "C", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "consumption_1_wNow" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "last" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Energy", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "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": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "collapsed": false, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 31 | |
| }, | |
| "id": 19, | |
| "panels": [], | |
| "title": "Array Stats", | |
| "type": "row" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": { | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 0, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 7, | |
| "x": 0, | |
| "y": 32 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 13, | |
| "legend": { | |
| "alignAsTable": false, | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "rightSide": false, | |
| "show": false, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.10", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "$tag_serialNumber", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "serialNumber" | |
| ], | |
| "type": "tag" | |
| } | |
| ], | |
| "measurement": "exec", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT \"lastReportWatts\" FROM \"exec\" WHERE (\"serialNumber\" = '121936006145' OR \"serialNumber\" = '121936003584' OR \"serialNumber\" = '121936003045' OR \"serialNumber\" = '121935179866' OR \"serialNumber\" = '121935178689' OR \"serialNumber\" = '121936007528' OR \"serialNumber\" = '121936007537' OR \"serialNumber\" = '121936016792') AND $timeFilter GROUP BY \"serialNumber\"", | |
| "rawQuery": true, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "lastReportWatts" | |
| ], | |
| "type": "field" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936006145" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936003584" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936003045" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121935179866" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121935178689" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936007528" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936007537" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936016792" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Panel Output NW Array Azimuth: 315º (8 Panels)", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "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": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": true, | |
| "cacheTimeout": null, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "Envoy", | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 0, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 7, | |
| "x": 7, | |
| "y": 32 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 26, | |
| "interval": null, | |
| "legend": { | |
| "alignAsTable": false, | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "rightSide": false, | |
| "show": false, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": false, | |
| "linewidth": 1, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.10", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "$tag_serialNumber", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "1s" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "serialNumber" | |
| ], | |
| "type": "tag" | |
| } | |
| ], | |
| "measurement": "exec", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT cumulative_sum(integral(\"lastReportWatts\")) /3600 FROM \"exec\" WHERE (\"serialNumber\" = '121936006145' OR \"serialNumber\" = '121936003584' OR \"serialNumber\" = '121936003045' OR \"serialNumber\" = '121935179866' OR \"serialNumber\" = '121935178689' OR \"serialNumber\" = '121936007528' OR \"serialNumber\" = '121936007537' OR \"serialNumber\" = '121936016792') AND $timeFilter GROUP BY time(1s), \"serialNumber\"", | |
| "rawQuery": true, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "lastReportWatts" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "integral" | |
| }, | |
| { | |
| "params": [], | |
| "type": "cumulative_sum" | |
| }, | |
| { | |
| "params": [ | |
| "/3600" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936006145" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936003584" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936003045" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121935179866" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121935178689" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936007528" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936007537" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936016792" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Panel Production NW Array Azimuth: 315º (8 Panels)", | |
| "tooltip": { | |
| "shared": false, | |
| "sort": 1, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "series", | |
| "name": null, | |
| "show": false, | |
| "values": [ | |
| "current" | |
| ] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "watth", | |
| "label": "", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": { | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 0, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 7, | |
| "x": 0, | |
| "y": 38 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 14, | |
| "legend": { | |
| "alignAsTable": false, | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "rightSide": false, | |
| "show": false, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.10", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "$tag_serialNumber", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "serialNumber" | |
| ], | |
| "type": "tag" | |
| } | |
| ], | |
| "measurement": "exec", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT \"lastReportWatts\" FROM \"exec\" WHERE ( \"serialNumber\" = '121936005752' OR \"serialNumber\" = '121936006772' or \"serialNumber\" = '121936006802' or \"serialNumber\" = '121936006804' or \"serialNumber\" = '121903080563' or \"serialNumber\" = '121936005346' or \"serialNumber\" = '121903078692' or \"serialNumber\" = '121903078568' or \"serialNumber\" = '121903077324' or \"serialNumber\" = '121935179520')\n AND $timeFilter GROUP BY \"serialNumber\"", | |
| "rawQuery": true, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "lastReportWatts" | |
| ], | |
| "type": "field" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936006145" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936003584" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936003045" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121935179866" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121935178689" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936007528" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936007537" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936016792" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Panel Output SE Array Azimuth: 135º (10 Panels)", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "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": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": true, | |
| "cacheTimeout": null, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "Envoy", | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 0, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 7, | |
| "x": 7, | |
| "y": 38 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 24, | |
| "interval": null, | |
| "legend": { | |
| "alignAsTable": false, | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "rightSide": false, | |
| "show": false, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": false, | |
| "linewidth": 1, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.10", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "$tag_serialNumber", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "1s" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "serialNumber" | |
| ], | |
| "type": "tag" | |
| } | |
| ], | |
| "measurement": "exec", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT cumulative_sum(integral(\"lastReportWatts\")) /3600 FROM \"exec\" WHERE (\"serialNumber\" = '121936005752' OR \"serialNumber\" = '121936006772' or \"serialNumber\" = '121936006802' or \"serialNumber\" = '121936006804' or \"serialNumber\" = '121903080563' or \"serialNumber\" = '121936005346' or \"serialNumber\" = '121903078692' or \"serialNumber\" = '121903078568' or \"serialNumber\" = '121903077324' or \"serialNumber\" = '121935179520') AND $timeFilter GROUP BY time(1s), \"serialNumber\"", | |
| "rawQuery": true, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "lastReportWatts" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "integral" | |
| }, | |
| { | |
| "params": [], | |
| "type": "cumulative_sum" | |
| }, | |
| { | |
| "params": [ | |
| "/3600" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936006145" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936003584" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936003045" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121935179866" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121935178689" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936007528" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936007537" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936016792" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Panel Production SE Array Azimuth: 135º (10 Panels)", | |
| "tooltip": { | |
| "shared": false, | |
| "sort": 1, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "series", | |
| "name": null, | |
| "show": false, | |
| "values": [ | |
| "current" | |
| ] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "watth", | |
| "label": "", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": { | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 0, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 7, | |
| "x": 0, | |
| "y": 44 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 15, | |
| "legend": { | |
| "alignAsTable": false, | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "rightSide": false, | |
| "show": false, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.10", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "$tag_serialNumber", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "serialNumber" | |
| ], | |
| "type": "tag" | |
| } | |
| ], | |
| "measurement": "exec", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT \"lastReportWatts\" FROM \"exec\" WHERE (\"serialNumber\" = '121903078561' or \"serialNumber\" = '121903078563' or \"serialNumber\" = '121903078571' or \"serialNumber\" = '121903078721' or \"serialNumber\" = '121903078741' or \"serialNumber\" = '121903078976' or \"serialNumber\" = '121903079110' or \"serialNumber\" = '121903079207' or \"serialNumber\" = '121903080646')\n AND $timeFilter GROUP BY \"serialNumber\"", | |
| "rawQuery": true, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "lastReportWatts" | |
| ], | |
| "type": "field" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936006145" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936003584" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936003045" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121935179866" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121935178689" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936007528" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936007537" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936016792" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Panel Output Flat Array Azimuth: 90º (9 Panels)", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "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": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": true, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "Envoy", | |
| "fieldConfig": { | |
| "defaults": { | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 0, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 7, | |
| "x": 7, | |
| "y": 44 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 25, | |
| "interval": "", | |
| "legend": { | |
| "alignAsTable": false, | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "rightSide": false, | |
| "show": false, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": false, | |
| "linewidth": 1, | |
| "maxDataPoints": 12333, | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.10", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "$tag_serialNumber", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "1s" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "serialNumber" | |
| ], | |
| "type": "tag" | |
| } | |
| ], | |
| "measurement": "exec", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": "SELECT cumulative_sum(integral(\"lastReportWatts\")) /3600 FROM \"exec\" WHERE (\"serialNumber\" = '121903078561' or \"serialNumber\" = '121903078563' or \"serialNumber\" = '121903078571' or \"serialNumber\" = '121903078721' or \"serialNumber\" = '121903078741' or \"serialNumber\" = '121903078976' or \"serialNumber\" = '121903079110' or \"serialNumber\" = '121903079207' or \"serialNumber\" = '121903080646') AND $timeFilter GROUP BY time(1s), \"serialNumber\"", | |
| "rawQuery": true, | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "lastReportWatts" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "integral" | |
| }, | |
| { | |
| "params": [], | |
| "type": "cumulative_sum" | |
| }, | |
| { | |
| "params": [ | |
| "/3600" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936006145" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936003584" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936003045" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121935179866" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121935178689" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936007528" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936007537" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "serialNumber", | |
| "operator": "=", | |
| "value": "121936016792" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Panel Production Flat Array Azimuth: 90º (9 Panels)", | |
| "tooltip": { | |
| "shared": false, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "series", | |
| "name": null, | |
| "show": false, | |
| "values": [ | |
| "current" | |
| ] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "watth", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| } | |
| ], | |
| "refresh": "", | |
| "schemaVersion": 27, | |
| "style": "dark", | |
| "tags": [], | |
| "templating": { | |
| "list": [] | |
| }, | |
| "time": { | |
| "from": "now-12h", | |
| "to": "now" | |
| }, | |
| "timepicker": {}, | |
| "timezone": "", | |
| "title": "Envoy", | |
| "uid": "ovNrVb7Mk", | |
| "version": 57 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment