Github Mirror / telegraf-plugins: 43c60e46

verified

Add Grafana Dashboard

Add Grafana Dashboard

Commit 43c60e46.

Authored 2023-07-15T10:35:30.000+01:00 by B Tasker in project Github Mirror / telegraf-plugins

+1089 lines -0 lines

Commit Signature

Changes

diff --git a/octopus-energy/grafana_dashboard.json b/octopus-energy/grafana_dashboard.json
--- a/octopus-energy/grafana_dashboard.json
+++ b/octopus-energy/grafana_dashboard.json
# @@ -0,0 +1,1089 @@
# +{
# + "__inputs": [
# + {
# + "name": "DS_INFLUXDB_(INFLUXQL)",
# + "label": "InfluxDB (InfluxQL)",
# + "description": "",
# + "type": "datasource",
# + "pluginId": "influxdb",
# + "pluginName": "InfluxDB"
# + }
# + ],
# + "__elements": {},
# + "__requires": [
# + {
# + "type": "grafana",
# + "id": "grafana",
# + "name": "Grafana",
# + "version": "9.5.1"
# + },
# + {
# + "type": "datasource",
# + "id": "influxdb",
# + "name": "InfluxDB",
# + "version": "1.0.0"
# + },
# + {
# + "type": "panel",
# + "id": "stat",
# + "name": "Stat",
# + "version": ""
# + },
# + {
# + "type": "panel",
# + "id": "timeseries",
# + "name": "Time series",
# + "version": ""
# + }
# + ],
# + "annotations": {
# + "list": [
# + {
# + "builtIn": 1,
# + "datasource": {
# + "type": "grafana",
# + "uid": "-- Grafana --"
# + },
# + "enable": true,
# + "hide": true,
# + "iconColor": "rgba(0, 211, 255, 1)",
# + "name": "Annotations & Alerts",
# + "type": "dashboard"
# + }
# + ]
# + },
# + "editable": true,
# + "fiscalYearStartMonth": 0,
# + "graphTooltip": 0,
# + "id": null,
# + "links": [],
# + "liveNow": false,
# + "panels": [
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "description": "",
# + "fieldConfig": {
# + "defaults": {
# + "color": {
# + "mode": "thresholds"
# + },
# + "mappings": [],
# + "thresholds": {
# + "mode": "absolute",
# + "steps": [
# + {
# + "color": "green",
# + "value": null
# + },
# + {
# + "color": "red",
# + "value": 80
# + }
# + ]
# + },
# + "unit": "currencyGBP"
# + },
# + "overrides": []
# + },
# + "id": 7,
# + "options": {
# + "colorMode": "value",
# + "graphMode": "area",
# + "justifyMode": "auto",
# + "orientation": "auto",
# + "reduceOptions": {
# + "calcs": [
# + "lastNotNull"
# + ],
# + "fields": "",
# + "values": false
# + },
# + "textMode": "auto"
# + },
# + "pluginVersion": "9.5.1",
# + "targets": [
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "query": "SELECT mean(\"cost_inc_vat\")/100 AS \"mean_cost_inc_vat\" FROM \"Systemstats\".\"autogen\".\"octopus_pricing\" WHERE $timeFilter AND \"charge_type\"='usage-charge' and tariff_direction != 'EXPORT' GROUP BY time(30m)",
# + "rawQuery": true,
# + "refId": "A",
# + "resultFormat": "time_series"
# + }
# + ],
# + "title": "Mean Import Cost per kWh",
# + "transformations": [
# + {
# + "id": "reduce",
# + "options": {
# + "reducers": [
# + "mean"
# + ]
# + }
# + }
# + ],
# + "type": "stat"
# + },
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "description": "",
# + "fieldConfig": {
# + "defaults": {
# + "color": {
# + "mode": "thresholds"
# + },
# + "mappings": [],
# + "thresholds": {
# + "mode": "absolute",
# + "steps": [
# + {
# + "color": "green",
# + "value": null
# + },
# + {
# + "color": "red",
# + "value": 80
# + }
# + ]
# + },
# + "unit": "currencyGBP"
# + },
# + "overrides": []
# + },
# + "gridPos": {
# + "h": 3,
# + "w": 6,
# + "x": 6,
# + "y": 0
# + },
# + "id": 8,
# + "options": {
# + "colorMode": "value",
# + "graphMode": "area",
# + "justifyMode": "auto",
# + "orientation": "auto",
# + "reduceOptions": {
# + "calcs": [
# + "lastNotNull"
# + ],
# + "fields": "",
# + "values": false
# + },
# + "textMode": "auto"
# + },
# + "pluginVersion": "9.5.1",
# + "targets": [
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "query": "SELECT mean(\"cost_inc_vat\")/100 AS \"mean_cost_inc_vat\" FROM \"Systemstats\".\"autogen\".\"octopus_pricing\" WHERE $timeFilter AND \"charge_type\"='usage-charge' and tariff_direction = 'EXPORT' GROUP BY time(30m)",
# + "rawQuery": true,
# + "refId": "A",
# + "resultFormat": "time_series"
# + }
# + ],
# + "title": "Mean Export Cost per kWh",
# + "transformations": [
# + {
# + "id": "reduce",
# + "options": {
# + "reducers": [
# + "mean"
# + ]
# + }
# + }
# + ],
# + "type": "stat"
# + },
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "description": "",
# + "fieldConfig": {
# + "defaults": {
# + "color": {
# + "mode": "thresholds"
# + },
# + "mappings": [],
# + "thresholds": {
# + "mode": "absolute",
# + "steps": [
# + {
# + "color": "green",
# + "value": null
# + },
# + {
# + "color": "red",
# + "value": 80
# + }
# + ]
# + },
# + "unit": "kwatth"
# + },
# + "overrides": []
# + },
# + "gridPos": {
# + "h": 3,
# + "w": 6,
# + "x": 12,
# + "y": 0
# + },
# + "id": 9,
# + "options": {
# + "colorMode": "value",
# + "graphMode": "area",
# + "justifyMode": "auto",
# + "orientation": "auto",
# + "reduceOptions": {
# + "calcs": [
# + "lastNotNull"
# + ],
# + "fields": "",
# + "values": false
# + },
# + "textMode": "auto"
# + },
# + "pluginVersion": "9.5.1",
# + "targets": [
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "query": "SELECT mean(\"consumption\") AS \"mean_consumption\" FROM \"Systemstats\".\"autogen\".\"octopus_consumption\" WHERE $timeFilter AND \"is_export\" !='True' GROUP BY time(30m) FILL(null)",
# + "rawQuery": true,
# + "refId": "A",
# + "resultFormat": "time_series"
# + }
# + ],
# + "title": "Total Import",
# + "transformations": [
# + {
# + "id": "reduce",
# + "options": {
# + "reducers": [
# + "mean"
# + ]
# + }
# + }
# + ],
# + "type": "stat"
# + },
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "description": "",
# + "fieldConfig": {
# + "defaults": {
# + "color": {
# + "mode": "thresholds"
# + },
# + "mappings": [],
# + "thresholds": {
# + "mode": "absolute",
# + "steps": [
# + {
# + "color": "green",
# + "value": null
# + },
# + {
# + "color": "red",
# + "value": 80
# + }
# + ]
# + },
# + "unit": "kwatth"
# + },
# + "overrides": []
# + },
# + "gridPos": {
# + "h": 3,
# + "w": 6,
# + "x": 18,
# + "y": 0
# + },
# + "id": 10,
# + "options": {
# + "colorMode": "value",
# + "graphMode": "area",
# + "justifyMode": "auto",
# + "orientation": "auto",
# + "reduceOptions": {
# + "calcs": [
# + "lastNotNull"
# + ],
# + "fields": "",
# + "values": false
# + },
# + "textMode": "auto"
# + },
# + "pluginVersion": "9.5.1",
# + "targets": [
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "query": "SELECT mean(\"consumption\") AS \"mean_consumption\" FROM \"Systemstats\".\"autogen\".\"octopus_consumption\" WHERE $timeFilter AND \"is_export\" ='True' GROUP BY time(30m) FILL(null)",
# + "rawQuery": true,
# + "refId": "A",
# + "resultFormat": "time_series"
# + }
# + ],
# + "title": "Total Import",
# + "transformations": [
# + {
# + "id": "reduce",
# + "options": {
# + "reducers": [
# + "mean"
# + ]
# + }
# + }
# + ],
# + "type": "stat"
# + },
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "description": "",
# + "fieldConfig": {
# + "defaults": {
# + "color": {
# + "mode": "palette-classic"
# + },
# + "custom": {
# + "axisCenteredZero": false,
# + "axisColorMode": "text",
# + "axisLabel": "",
# + "axisPlacement": "auto",
# + "barAlignment": 0,
# + "drawStyle": "line",
# + "fillOpacity": 0,
# + "gradientMode": "none",
# + "hideFrom": {
# + "legend": false,
# + "tooltip": false,
# + "viz": false
# + },
# + "lineInterpolation": "linear",
# + "lineWidth": 1,
# + "pointSize": 5,
# + "scaleDistribution": {
# + "type": "linear"
# + },
# + "showPoints": "auto",
# + "spanNulls": false,
# + "stacking": {
# + "group": "A",
# + "mode": "none"
# + },
# + "thresholdsStyle": {
# + "mode": "off"
# + }
# + },
# + "mappings": [],
# + "thresholds": {
# + "mode": "absolute",
# + "steps": [
# + {
# + "color": "green",
# + "value": null
# + },
# + {
# + "color": "red",
# + "value": 80
# + }
# + ]
# + },
# + "unit": "currencyGBP"
# + },
# + "overrides": [
# + {
# + "__systemRef": "hideSeriesFrom",
# + "matcher": {
# + "id": "byNames",
# + "options": {
# + "mode": "exclude",
# + "names": [
# + "octopus_pricing.mean_cost_inc_vat {tariff_code: E-1R-AGILE-FLEX-22-11-25-A}"
# + ],
# + "prefix": "All except:",
# + "readOnly": true
# + }
# + },
# + "properties": [
# + {
# + "id": "custom.hideFrom",
# + "value": {
# + "legend": false,
# + "tooltip": false,
# + "viz": true
# + }
# + }
# + ]
# + }
# + ]
# + },
# + "gridPos": {
# + "h": 8,
# + "w": 12,
# + "x": 0,
# + "y": 3
# + },
# + "id": 1,
# + "options": {
# + "legend": {
# + "calcs": [],
# + "displayMode": "list",
# + "placement": "bottom",
# + "showLegend": true
# + },
# + "tooltip": {
# + "mode": "single",
# + "sort": "none"
# + }
# + },
# + "targets": [
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "query": "SELECT mean(\"cost_inc_vat\")/100 AS \"mean_cost_inc_vat\" FROM \"Systemstats\".\"autogen\".\"octopus_pricing\" WHERE $timeFilter AND \"charge_type\"='usage-charge' and tariff_direction != 'EXPORT' GROUP BY time(30m), \"tariff_code\" FILL(null)",
# + "rawQuery": true,
# + "refId": "A",
# + "resultFormat": "time_series"
# + }
# + ],
# + "title": "Cost per kWh",
# + "type": "timeseries"
# + },
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "description": "",
# + "fieldConfig": {
# + "defaults": {
# + "color": {
# + "mode": "palette-classic"
# + },
# + "custom": {
# + "axisCenteredZero": false,
# + "axisColorMode": "text",
# + "axisLabel": "",
# + "axisPlacement": "auto",
# + "barAlignment": 0,
# + "drawStyle": "line",
# + "fillOpacity": 0,
# + "gradientMode": "none",
# + "hideFrom": {
# + "legend": false,
# + "tooltip": false,
# + "viz": false
# + },
# + "lineInterpolation": "linear",
# + "lineWidth": 1,
# + "pointSize": 5,
# + "scaleDistribution": {
# + "type": "linear"
# + },
# + "showPoints": "auto",
# + "spanNulls": false,
# + "stacking": {
# + "group": "A",
# + "mode": "none"
# + },
# + "thresholdsStyle": {
# + "mode": "off"
# + }
# + },
# + "mappings": [],
# + "thresholds": {
# + "mode": "absolute",
# + "steps": [
# + {
# + "color": "green",
# + "value": null
# + },
# + {
# + "color": "red",
# + "value": 80
# + }
# + ]
# + },
# + "unit": "kwatth"
# + },
# + "overrides": []
# + },
# + "gridPos": {
# + "h": 8,
# + "w": 12,
# + "x": 12,
# + "y": 3
# + },
# + "id": 2,
# + "options": {
# + "legend": {
# + "calcs": [],
# + "displayMode": "list",
# + "placement": "bottom",
# + "showLegend": true
# + },
# + "tooltip": {
# + "mode": "single",
# + "sort": "none"
# + }
# + },
# + "targets": [
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "query": "SELECT mean(\"consumption\") AS \"mean_consumption\" FROM \"Systemstats\".\"autogen\".\"octopus_consumption\" WHERE $timeFilter AND \"is_export\" !='True' GROUP BY time(30m) FILL(null)",
# + "rawQuery": true,
# + "refId": "A",
# + "resultFormat": "time_series"
# + }
# + ],
# + "title": "Consumption",
# + "type": "timeseries"
# + },
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "description": "",
# + "fieldConfig": {
# + "defaults": {
# + "color": {
# + "mode": "palette-classic"
# + },
# + "custom": {
# + "axisCenteredZero": false,
# + "axisColorMode": "text",
# + "axisLabel": "",
# + "axisPlacement": "auto",
# + "barAlignment": 0,
# + "drawStyle": "line",
# + "fillOpacity": 0,
# + "gradientMode": "none",
# + "hideFrom": {
# + "legend": false,
# + "tooltip": false,
# + "viz": false
# + },
# + "lineInterpolation": "linear",
# + "lineWidth": 1,
# + "pointSize": 5,
# + "scaleDistribution": {
# + "type": "linear"
# + },
# + "showPoints": "auto",
# + "spanNulls": false,
# + "stacking": {
# + "group": "A",
# + "mode": "none"
# + },
# + "thresholdsStyle": {
# + "mode": "off"
# + }
# + },
# + "mappings": [],
# + "thresholds": {
# + "mode": "absolute",
# + "steps": [
# + {
# + "color": "green",
# + "value": null
# + },
# + {
# + "color": "red",
# + "value": 80
# + }
# + ]
# + },
# + "unit": "currencyGBP"
# + },
# + "overrides": []
# + },
# + "gridPos": {
# + "h": 9,
# + "w": 24,
# + "x": 0,
# + "y": 11
# + },
# + "id": 5,
# + "options": {
# + "legend": {
# + "calcs": [],
# + "displayMode": "list",
# + "placement": "bottom",
# + "showLegend": true
# + },
# + "tooltip": {
# + "mode": "single",
# + "sort": "none"
# + }
# + },
# + "targets": [
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "query": "SELECT mean(\"consumption\") AS \"mean_consumption\" FROM \"Systemstats\".\"autogen\".\"octopus_consumption\" WHERE $timeFilter AND \"is_export\" !='True' GROUP BY time(30m) ",
# + "rawQuery": true,
# + "refId": "A",
# + "resultFormat": "time_series"
# + },
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "hide": false,
# + "query": "SELECT mean(\"cost_inc_vat\")/100 AS \"mean_cost_inc_vat\" FROM \"Systemstats\".\"autogen\".\"octopus_pricing\" WHERE $timeFilter AND \"charge_type\"='usage-charge' and tariff_direction != 'EXPORT' GROUP BY time(30m) ",
# + "rawQuery": true,
# + "refId": "B",
# + "resultFormat": "time_series"
# + }
# + ],
# + "title": "Consumption Cost",
# + "transformations": [
# + {
# + "id": "joinByField",
# + "options": {
# + "byField": "Time",
# + "mode": "outer"
# + }
# + },
# + {
# + "id": "calculateField",
# + "options": {
# + "alias": "consumption_cost",
# + "binary": {
# + "left": "octopus_consumption.mean_consumption",
# + "operator": "*",
# + "reducer": "sum",
# + "right": "octopus_pricing.mean_cost_inc_vat"
# + },
# + "mode": "binary",
# + "reduce": {
# + "reducer": "sum"
# + },
# + "replaceFields": true
# + }
# + }
# + ],
# + "type": "timeseries"
# + },
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "description": "",
# + "fieldConfig": {
# + "defaults": {
# + "color": {
# + "mode": "palette-classic"
# + },
# + "custom": {
# + "axisCenteredZero": false,
# + "axisColorMode": "text",
# + "axisLabel": "",
# + "axisPlacement": "auto",
# + "barAlignment": 0,
# + "drawStyle": "line",
# + "fillOpacity": 0,
# + "gradientMode": "none",
# + "hideFrom": {
# + "legend": false,
# + "tooltip": false,
# + "viz": false
# + },
# + "lineInterpolation": "linear",
# + "lineWidth": 1,
# + "pointSize": 5,
# + "scaleDistribution": {
# + "type": "linear"
# + },
# + "showPoints": "auto",
# + "spanNulls": false,
# + "stacking": {
# + "group": "A",
# + "mode": "none"
# + },
# + "thresholdsStyle": {
# + "mode": "off"
# + }
# + },
# + "mappings": [],
# + "thresholds": {
# + "mode": "absolute",
# + "steps": [
# + {
# + "color": "green",
# + "value": null
# + },
# + {
# + "color": "red",
# + "value": 80
# + }
# + ]
# + },
# + "unit": "currencyGBP"
# + },
# + "overrides": [
# + {
# + "__systemRef": "hideSeriesFrom",
# + "matcher": {
# + "id": "byNames",
# + "options": {
# + "mode": "exclude",
# + "names": [
# + "octopus_pricing.mean_cost_inc_vat {tariff_code: E-1R-AGILE-FLEX-22-11-25-A}"
# + ],
# + "prefix": "All except:",
# + "readOnly": true
# + }
# + },
# + "properties": [
# + {
# + "id": "custom.hideFrom",
# + "value": {
# + "legend": false,
# + "tooltip": false,
# + "viz": true
# + }
# + }
# + ]
# + }
# + ]
# + },
# + "gridPos": {
# + "h": 8,
# + "w": 12,
# + "x": 0,
# + "y": 20
# + },
# + "id": 3,
# + "options": {
# + "legend": {
# + "calcs": [],
# + "displayMode": "list",
# + "placement": "bottom",
# + "showLegend": true
# + },
# + "tooltip": {
# + "mode": "single",
# + "sort": "none"
# + }
# + },
# + "targets": [
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "query": "SELECT mean(\"cost_inc_vat\")/100 AS \"mean_cost_inc_vat\" FROM \"Systemstats\".\"autogen\".\"octopus_pricing\" WHERE $timeFilter AND \"charge_type\"='usage-charge' and tariff_direction = 'EXPORT' GROUP BY time(30m), \"tariff_code\" FILL(null)",
# + "rawQuery": true,
# + "refId": "A",
# + "resultFormat": "time_series"
# + }
# + ],
# + "title": "Export Price per kWh",
# + "type": "timeseries"
# + },
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "description": "",
# + "fieldConfig": {
# + "defaults": {
# + "color": {
# + "mode": "palette-classic"
# + },
# + "custom": {
# + "axisCenteredZero": false,
# + "axisColorMode": "text",
# + "axisLabel": "",
# + "axisPlacement": "auto",
# + "barAlignment": 0,
# + "drawStyle": "line",
# + "fillOpacity": 0,
# + "gradientMode": "none",
# + "hideFrom": {
# + "legend": false,
# + "tooltip": false,
# + "viz": false
# + },
# + "lineInterpolation": "linear",
# + "lineWidth": 1,
# + "pointSize": 5,
# + "scaleDistribution": {
# + "type": "linear"
# + },
# + "showPoints": "auto",
# + "spanNulls": false,
# + "stacking": {
# + "group": "A",
# + "mode": "none"
# + },
# + "thresholdsStyle": {
# + "mode": "off"
# + }
# + },
# + "mappings": [],
# + "thresholds": {
# + "mode": "absolute",
# + "steps": [
# + {
# + "color": "green",
# + "value": null
# + },
# + {
# + "color": "red",
# + "value": 80
# + }
# + ]
# + },
# + "unit": "kwatth"
# + },
# + "overrides": []
# + },
# + "gridPos": {
# + "h": 8,
# + "w": 12,
# + "x": 12,
# + "y": 20
# + },
# + "id": 4,
# + "options": {
# + "legend": {
# + "calcs": [],
# + "displayMode": "list",
# + "placement": "bottom",
# + "showLegend": true
# + },
# + "tooltip": {
# + "mode": "single",
# + "sort": "none"
# + }
# + },
# + "targets": [
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "query": "SELECT mean(\"consumption\") AS \"mean_consumption\" FROM \"Systemstats\".\"autogen\".\"octopus_consumption\" WHERE $timeFilter AND is_export=\"True\" GROUP BY time(30m) FILL(null)",
# + "rawQuery": true,
# + "refId": "A",
# + "resultFormat": "time_series"
# + }
# + ],
# + "title": "Export",
# + "type": "timeseries"
# + },
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "description": "",
# + "fieldConfig": {
# + "defaults": {
# + "color": {
# + "mode": "palette-classic"
# + },
# + "custom": {
# + "axisCenteredZero": false,
# + "axisColorMode": "text",
# + "axisLabel": "",
# + "axisPlacement": "auto",
# + "barAlignment": 0,
# + "drawStyle": "line",
# + "fillOpacity": 0,
# + "gradientMode": "none",
# + "hideFrom": {
# + "legend": false,
# + "tooltip": false,
# + "viz": false
# + },
# + "lineInterpolation": "linear",
# + "lineWidth": 1,
# + "pointSize": 5,
# + "scaleDistribution": {
# + "type": "linear"
# + },
# + "showPoints": "auto",
# + "spanNulls": false,
# + "stacking": {
# + "group": "A",
# + "mode": "none"
# + },
# + "thresholdsStyle": {
# + "mode": "off"
# + }
# + },
# + "mappings": [],
# + "thresholds": {
# + "mode": "absolute",
# + "steps": [
# + {
# + "color": "green",
# + "value": null
# + },
# + {
# + "color": "red",
# + "value": 80
# + }
# + ]
# + },
# + "unit": "currencyGBP"
# + },
# + "overrides": [
# + {
# + "__systemRef": "hideSeriesFrom",
# + "matcher": {
# + "id": "byNames",
# + "options": {
# + "mode": "exclude",
# + "names": [
# + "export_value"
# + ],
# + "prefix": "All except:",
# + "readOnly": true
# + }
# + },
# + "properties": [
# + {
# + "id": "custom.hideFrom",
# + "value": {
# + "legend": false,
# + "tooltip": false,
# + "viz": true
# + }
# + }
# + ]
# + }
# + ]
# + },
# + "gridPos": {
# + "h": 8,
# + "w": 24,
# + "x": 0,
# + "y": 28
# + },
# + "id": 6,
# + "options": {
# + "legend": {
# + "calcs": [],
# + "displayMode": "list",
# + "placement": "bottom",
# + "showLegend": true
# + },
# + "tooltip": {
# + "mode": "single",
# + "sort": "none"
# + }
# + },
# + "targets": [
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "query": "SELECT mean(\"cost_inc_vat\")/100 AS \"mean_cost_inc_vat\" FROM \"Systemstats\".\"autogen\".\"octopus_pricing\" WHERE $timeFilter AND \"charge_type\"='usage-charge' and tariff_direction = 'EXPORT' GROUP BY time(30m)",
# + "rawQuery": true,
# + "refId": "A",
# + "resultFormat": "time_series"
# + },
# + {
# + "datasource": {
# + "type": "influxdb",
# + "uid": "${DS_INFLUXDB_(INFLUXQL)}"
# + },
# + "hide": false,
# + "query": "SELECT mean(\"consumption\") AS \"mean_consumption\" FROM \"Systemstats\".\"autogen\".\"octopus_consumption\" WHERE $timeFilter AND is_export =\"True\" GROUP BY time(30m) ",
# + "rawQuery": true,
# + "refId": "B",
# + "resultFormat": "time_series"
# + }
# + ],
# + "title": "Export Price per kWh",
# + "transformations": [
# + {
# + "id": "joinByField",
# + "options": {
# + "byField": "Time",
# + "mode": "outer"
# + }
# + },
# + {
# + "id": "calculateField",
# + "options": {
# + "alias": "export_value",
# + "binary": {
# + "left": "octopus_pricing.mean_cost_inc_vat",
# + "operator": "*",
# + "reducer": "sum",
# + "right": "octopus_consumption.mean_consumption"
# + },
# + "mode": "binary",
# + "reduce": {
# + "reducer": "sum"
# + },
# + "replaceFields": true
# + }
# + }
# + ],
# + "type": "timeseries"
# + }
# + ],
# + "refresh": "",
# + "schemaVersion": 38,
# + "style": "dark",
# + "tags": [
# + "Octopus",
# + "electricity",
# + "utilities"
# + ],
# + "templating": {
# + "list": []
# + },
# + "time": {
# + "from": "now-24h",
# + "to": "now+24h"
# + },
# + "timepicker": {},
# + "timezone": "",
# + "title": "Octopus Pricing",
# + "uid": "ffb833f8-fae9-4b8c-9b14-99a2c2d9e8f2",
# + "version": 10,
# + "weekStart": ""
# +}
# \ No newline at end of file
#