Created
December 12, 2020 21:43
-
-
Save scline/8b454fdc49b7643933405849758abec4 to your computer and use it in GitHub Desktop.
This file contains 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": 2, | |
| "iteration": 1607809236979, | |
| "links": [], | |
| "panels": [ | |
| { | |
| "collapsed": false, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 0 | |
| }, | |
| "id": 16, | |
| "panels": [], | |
| "title": "Cost", | |
| "type": "row" | |
| }, | |
| { | |
| "datasource": "InfluxDB - emporia", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "#EAB839", | |
| "value": 15000 | |
| }, | |
| { | |
| "color": "red", | |
| "value": 20000 | |
| } | |
| ] | |
| }, | |
| "unit": "currencyUSD" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 4, | |
| "x": 0, | |
| "y": 1 | |
| }, | |
| "id": 5, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "7.3.3", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "energy_usage", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "usage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [ | |
| " / 1000 *0.125" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "account_name", | |
| "operator": "=~", | |
| "value": "/^$account$/" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "=", | |
| "value": "Home" | |
| } | |
| ] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Cost per Hour (Current)", | |
| "type": "stat" | |
| }, | |
| { | |
| "aliasColors": { | |
| "Cost": "dark-green", | |
| "Home": "yellow" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "InfluxDB - emporia", | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 8, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 16, | |
| "x": 4, | |
| "y": 1 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 3, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "hideZero": true, | |
| "max": false, | |
| "min": false, | |
| "rightSide": false, | |
| "show": false, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.3.3", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "Cost", | |
| "yaxis": 1 | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "Cost", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "device_name" | |
| ], | |
| "type": "tag" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "energy_usage", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "B", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "usage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [ | |
| " / 1000 * .125" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "account_name", | |
| "operator": "=", | |
| "value": "Home" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "=", | |
| "value": "Home" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Whole House Power Cost", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "decimals": 2, | |
| "format": "currencyUSD", | |
| "label": "Cost per Hour", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "decimals": 2, | |
| "format": "currencyUSD", | |
| "label": "Cost per Hour", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "datasource": "InfluxDB - emporia", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "#EAB839", | |
| "value": 15000 | |
| }, | |
| { | |
| "color": "red", | |
| "value": 20000 | |
| } | |
| ] | |
| }, | |
| "unit": "currencyUSD" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 4, | |
| "x": 20, | |
| "y": 1 | |
| }, | |
| "id": 12, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "mean" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "7.3.3", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "energy_usage", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "usage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [ | |
| " / 1000 *0.125" | |
| ], | |
| "type": "math" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "account_name", | |
| "operator": "=~", | |
| "value": "/^$account$/" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "=", | |
| "value": "Home" | |
| } | |
| ] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Average Cost per Hour", | |
| "type": "stat" | |
| }, | |
| { | |
| "collapsed": false, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 8 | |
| }, | |
| "id": 14, | |
| "panels": [], | |
| "title": "Power Consumption", | |
| "type": "row" | |
| }, | |
| { | |
| "datasource": "InfluxDB - emporia", | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "decimals": 2, | |
| "mappings": [], | |
| "max": 24000, | |
| "min": 0, | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "#EAB839", | |
| "value": 15000 | |
| }, | |
| { | |
| "color": "red", | |
| "value": 20000 | |
| } | |
| ] | |
| }, | |
| "unit": "watt" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 9, | |
| "w": 4, | |
| "x": 0, | |
| "y": 9 | |
| }, | |
| "id": 10, | |
| "options": { | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "showThresholdLabels": false, | |
| "showThresholdMarkers": true | |
| }, | |
| "pluginVersion": "7.3.3", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "energy_usage", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "usage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "account_name", | |
| "operator": "=~", | |
| "value": "/^$account$/" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "=", | |
| "value": "Home" | |
| } | |
| ] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Whole House (Current)", | |
| "type": "gauge" | |
| }, | |
| { | |
| "aliasColors": { | |
| "Cost": "dark-green", | |
| "Home": "yellow" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "InfluxDB - emporia", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 8, | |
| "gridPos": { | |
| "h": 9, | |
| "w": 18, | |
| "x": 4, | |
| "y": 9 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 11, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "hideZero": true, | |
| "max": false, | |
| "min": false, | |
| "rightSide": false, | |
| "show": false, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.3.3", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "Cost", | |
| "yaxis": 2 | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "$tag_device_name", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "device_name" | |
| ], | |
| "type": "tag" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "energy_usage", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "usage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "account_name", | |
| "operator": "=~", | |
| "value": "/^$account$/" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "=", | |
| "value": "Home" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Whole House Circuit Usage", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "watt", | |
| "label": "Watts", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "decimals": 2, | |
| "format": "currencyUSD", | |
| "label": "Cost per Hour", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "datasource": "InfluxDB - emporia", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "semi-dark-red", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "watt" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 2, | |
| "x": 22, | |
| "y": 9 | |
| }, | |
| "id": 18, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "max" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "7.3.3", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "energy_usage", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "usage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "account_name", | |
| "operator": "=", | |
| "value": "Home" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "=", | |
| "value": "Home" | |
| } | |
| ] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "HIGH", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": "InfluxDB - emporia", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "dark-green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "watt" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 2, | |
| "x": 22, | |
| "y": 12 | |
| }, | |
| "id": 20, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "mean" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "7.3.3", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "energy_usage", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "usage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "account_name", | |
| "operator": "=", | |
| "value": "Home" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "=", | |
| "value": "Home" | |
| } | |
| ] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "AVERAGE", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": "InfluxDB - emporia", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "dark-blue", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "watt" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 2, | |
| "x": 22, | |
| "y": 15 | |
| }, | |
| "id": 19, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "min" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "7.3.3", | |
| "targets": [ | |
| { | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "energy_usage", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "usage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "account_name", | |
| "operator": "=", | |
| "value": "Home" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "=", | |
| "value": "Home" | |
| } | |
| ] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "LOW", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": "InfluxDB - emporia", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "mappings": [], | |
| "max": 2400, | |
| "min": 0, | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "#EAB839", | |
| "value": 1500 | |
| }, | |
| { | |
| "color": "red", | |
| "value": 2000 | |
| } | |
| ] | |
| }, | |
| "unit": "watt" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 8, | |
| "x": 0, | |
| "y": 18 | |
| }, | |
| "id": 7, | |
| "options": { | |
| "displayMode": "lcd", | |
| "orientation": "horizontal", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "showUnfilled": true | |
| }, | |
| "pluginVersion": "7.3.3", | |
| "targets": [ | |
| { | |
| "alias": "$tag_device_name", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "device_name" | |
| ], | |
| "type": "tag" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "energy_usage", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "usage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "account_name", | |
| "operator": "=~", | |
| "value": "/^$account$/" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "!=", | |
| "value": "Home" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "!=", | |
| "value": "AC_Downstairs" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "!=", | |
| "value": "AC_Upstairs" | |
| } | |
| ] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Room Usage", | |
| "type": "bargauge" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "InfluxDB - emporia", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [], | |
| "unit": "watt" | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 16, | |
| "x": 8, | |
| "y": 18 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 2, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "hideZero": true, | |
| "max": false, | |
| "min": false, | |
| "rightSide": true, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.3.3", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "$tag_device_name", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "device_name" | |
| ], | |
| "type": "tag" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "energy_usage", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "usage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "account_name", | |
| "operator": "=~", | |
| "value": "/^$account$/" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "!=", | |
| "value": "Home" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "!=", | |
| "value": "AC_Downstairs" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "!=", | |
| "value": "AC_Upstairs" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Room Circuit Usage", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "watt", | |
| "label": "Watts", | |
| "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 | |
| } | |
| }, | |
| { | |
| "datasource": "InfluxDB - emporia", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "mappings": [], | |
| "max": 9600, | |
| "min": 0, | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "#EAB839", | |
| "value": 6600 | |
| }, | |
| { | |
| "color": "red", | |
| "value": 8600 | |
| } | |
| ] | |
| }, | |
| "unit": "watt" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 8, | |
| "x": 0, | |
| "y": 26 | |
| }, | |
| "id": 8, | |
| "options": { | |
| "displayMode": "lcd", | |
| "orientation": "horizontal", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "showUnfilled": true | |
| }, | |
| "pluginVersion": "7.3.3", | |
| "targets": [ | |
| { | |
| "alias": "$tag_device_name", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "device_name" | |
| ], | |
| "type": "tag" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "energy_usage", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "usage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "account_name", | |
| "operator": "=~", | |
| "value": "/^$account$/" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "!=", | |
| "value": "Home" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "=", | |
| "value": "AC_Downstairs" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "device_name", | |
| "operator": "=", | |
| "value": "AC_Upstairs" | |
| } | |
| ] | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Air Conditioning", | |
| "type": "bargauge" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "InfluxDB - emporia", | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 16, | |
| "x": 8, | |
| "y": 26 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 9, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "hideZero": true, | |
| "max": false, | |
| "min": false, | |
| "rightSide": true, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.3.3", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "$tag_device_name", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "device_name" | |
| ], | |
| "type": "tag" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "measurement": "energy_usage", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "usage" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [ | |
| { | |
| "key": "account_name", | |
| "operator": "=~", | |
| "value": "/^$account$/" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "!=", | |
| "value": "Home" | |
| }, | |
| { | |
| "condition": "AND", | |
| "key": "device_name", | |
| "operator": "=", | |
| "value": "AC_Downstairs" | |
| }, | |
| { | |
| "condition": "OR", | |
| "key": "device_name", | |
| "operator": "=", | |
| "value": "AC_Upstairs" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "AC Circuit Usage", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "label": "Watts", | |
| "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": "5s", | |
| "schemaVersion": 26, | |
| "style": "dark", | |
| "tags": [], | |
| "templating": { | |
| "list": [ | |
| { | |
| "allValue": "All", | |
| "current": { | |
| "selected": false, | |
| "text": "Home", | |
| "value": "Home" | |
| }, | |
| "datasource": "InfluxDB - emporia", | |
| "definition": "SHOW TAG VALUES FROM energy_usage WITH KEY = account_name", | |
| "error": null, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": "", | |
| "multi": false, | |
| "name": "account", | |
| "options": [], | |
| "query": "SHOW TAG VALUES FROM energy_usage WITH KEY = account_name", | |
| "refresh": 1, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": "All", | |
| "current": { | |
| "selected": false, | |
| "text": "AC_Downstairs", | |
| "value": "AC_Downstairs" | |
| }, | |
| "datasource": "InfluxDB - emporia", | |
| "definition": "SHOW TAG VALUES FROM energy_usage WITH KEY = device_name", | |
| "error": null, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": "", | |
| "multi": false, | |
| "name": "device_name", | |
| "options": [], | |
| "query": "SHOW TAG VALUES FROM energy_usage WITH KEY = device_name", | |
| "refresh": 1, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| } | |
| ] | |
| }, | |
| "time": { | |
| "from": "now-6h", | |
| "to": "now" | |
| }, | |
| "timepicker": { | |
| "refresh_intervals": [ | |
| "5s", | |
| "10s", | |
| "30s", | |
| "1m", | |
| "5m", | |
| "15m", | |
| "30m", | |
| "1h", | |
| "2h", | |
| "1d" | |
| ] | |
| }, | |
| "timezone": "", | |
| "title": "Energy Usage", | |
| "uid": "8hz6lWCZz", | |
| "version": 2 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
JSON Export of https://metrics.packetpals.com/d/8hz6lWCZz/energy-usage