This is a complete walk through in order to get energy monitoring with a Shelly em3 and InfluxDB with Grafana through mqtt up and running on DSM7. We will not use Node Red instead Telegraf directly subscribes the topics and pushes them into the database.
For now there are some hick ups and there seem to be some delays between some messages. This is early state though and I have to see how this develops.
- Have Docker installed.
- Create a group called
dockerin DSM. - Put your user into this group to avoid sudo for docker related stuff.
- SSH enabled in DSM.
- Have a shared folder
docker, will be accessible at/volume1/docker
SSH into Synology
- Create a folder for portainer's persistance:
mkdir /volume1/docker/portainer/ - Create a folder for portainer's docker compose file, like
mkdir docker-portainer - In there create
docker-compose.ymlwith contents:
version: '3'
services:
portainer:
image: portainer/portainer-ce:latest
container_name: portainer
restart: always
ports:
- 9000:9000
volumes:
- /var/run/docker.sock:/var/run/docker.sock
- /volume1/docker/portainer/:/data
- Then run
docker-compose up -dand login to poertainer at port 9000.
For later updates of portainer cd to where the yml lives and run
docker-compose pull
docker-compose up -d
Create some needed dirs and files for persistance data:
mkdir -p /volume1/docker/energy-monitoring/mosquitto/data
mkdir -p /volume1/docker/energy-monitoring/influxdb2
mkdir -p /volume1/docker/energy-monitoring/telegraf
touch /volume1/docker/energy-monitoring/mosquitto/mosquitto.log
persistence true
persistence_location /mosquitto/data/
log_dest file /mosquitto/log/mosquitto.log
allow_anonymous true
listener 1883 0.0.0.0
protocol mqtt
listener 9001 0.0.0.0
protocol websockets
[agent]
## Default data collection interval for all inputs
interval = "10s"
## Rounds collection interval to 'interval'
## ie, if interval="10s" then always collect on :00, :10, :20, etc.
round_interval = true
## Telegraf will send metrics to outputs in batches of at most
## metric_batch_size metrics.
## This controls the size of writes that Telegraf sends to output plugins.
metric_batch_size = 1000
## Maximum number of unwritten metrics per output. Increasing this value
## allows for longer periods of output downtime without dropping metrics at the
## cost of higher maximum memory usage.
metric_buffer_limit = 10000
## Collection jitter is used to jitter the collection by a random amount.
## Each plugin will sleep for a random time within jitter before collecting.
## This can be used to avoid many plugins querying things like sysfs at the
## same time, which can have a measurable effect on the system.
collection_jitter = "0s"
## Default flushing interval for all outputs. Maximum flush_interval will be
## flush_interval + flush_jitter
flush_interval = "10s"
## Jitter the flush interval by a random amount. This is primarily to avoid
## large write spikes for users running a large number of telegraf instances.
## ie, a jitter of 5s and interval 10s means flushes will happen every 10-15s
flush_jitter = "0s"
## By default or when set to "0s", precision will be set to the same
## timestamp order as the collection interval, with the maximum being 1s.
## ie, when interval = "10s", precision will be "1s"
## when interval = "250ms", precision will be "1ms"
## Precision will NOT be used for service inputs. It is up to each individual
## service input to set the timestamp at the appropriate precision.
## Valid time units are "ns", "us" (or "µs"), "ms", "s".
precision = ""
## Log at debug level.
# debug = false
## Log only error level messages.
# quiet = false
## Log target controls the destination for logs and can be one of "file",
## "stderr" or, on Windows, "eventlog". When set to "file", the output file
## is determined by the "logfile" setting.
# logtarget = "file"
## Name of the file to be logged to when using the "file" logtarget. If set to
## the empty string then logs are written to stderr.
# logfile = ""
## The logfile will be rotated after the time interval specified. When set
## to 0 no time based rotation is performed. Logs are rotated only when
## written to, if there is no log activity rotation may be delayed.
# logfile_rotation_interval = "0d"
## The logfile will be rotated when it becomes larger than the specified
## size. When set to 0 no size based rotation is performed.
# logfile_rotation_max_size = "0MB"
## Maximum number of rotated archives to keep, any older logs are deleted.
## If set to -1, no archives are removed.
# logfile_rotation_max_archives = 5
## Pick a timezone to use when logging or type 'local' for local time.
## Example: America/Chicago
# log_with_timezone = ""
## Override default hostname, if empty use os.Hostname()
hostname = ""
## If set to true, do no set the "host" tag in the telegraf agent.
omit_hostname = false
[[outputs.influxdb_v2]]
## The URLs of the InfluxDB cluster nodes.
##
## Multiple URLs can be specified for a single cluster, only ONE of the
## urls will be written to each interval.
## ex: urls = ["https://us-west-2-1.aws.cloud2.influxdata.com"]
urls = ["http://influxdb:8086"]
## Token for authentication.
token = "$INFLUX_TOKEN"
## Organization is the name of the organization you wish to write to; must exist.
organization = "myorg"
## Destination bucket to write into.
bucket = "energy-monitoring"
## The value of this tag will be used to determine the bucket. If this
## tag is not set the 'bucket' option is used as the default.
# bucket_tag = ""
## If true, the bucket tag will not be added to the metric.
# exclude_bucket_tag = false
## Timeout for HTTP messages.
# timeout = "5s"
## Additional HTTP headers
# http_headers = {"X-Special-Header" = "Special-Value"}
## HTTP Proxy override, if unset values the standard proxy environment
## variables are consulted to determine which proxy, if any, should be used.
# http_proxy = "http://corporate.proxy:3128"
## HTTP User-Agent
# user_agent = "telegraf"
## Content-Encoding for write request body, can be set to "gzip" to
## compress body or "identity" to apply no encoding.
# content_encoding = "gzip"
## Enable or disable uint support for writing uints influxdb 2.0.
# influx_uint_support = false
## Optional TLS Config for use on HTTP connections.
# tls_ca = "/etc/telegraf/ca.pem"
# tls_cert = "/etc/telegraf/cert.pem"
# tls_key = "/etc/telegraf/key.pem"
## Use TLS but skip chain & host verification
# insecure_skip_verify = false
# Read metrics from MQTT topic(s)
[[inputs.mqtt_consumer]]
## Broker URLs for the MQTT server or cluster. To connect to multiple
## clusters or standalone servers, use a separate plugin instance.
## example: servers = ["tcp://localhost:1883"]
## servers = ["ssl://localhost:1883"]
## servers = ["ws://localhost:1883"]
servers = ["tcp://mosquitto:1883"]
## Topics that will be subscribed to.
topics = [
"shellies/+/emeter/+/#",
#"shellies/+/relay/+/#",
]
data_format = "value"
data_type = "float"
# topic_fields = "_/_/_/temperature"
## The message topic will be stored in a tag specified by this value. If set
## to the empty string no topic tag will be created.
# topic_tag = "topic"
## QoS policy for messages
## 0 = at most once
## 1 = at least once
## 2 = exactly once
##
## When using a QoS of 1 or 2, you should enable persistent_session to allow
## resuming unacknowledged messages.
# qos = 0
## Connection timeout for initial connection in seconds
# connection_timeout = "30s"
## Maximum messages to read from the broker that have not been written by an
## output. For best throughput set based on the number of metrics within
## each message and the size of the output's metric_batch_size.
##
## For example, if each message from the queue contains 10 metrics and the
## output metric_batch_size is 1000, setting this to 100 will ensure that a
## full batch is collected and the write is triggered immediately without
## waiting until the next flush_interval.
# max_undelivered_messages = 1000
## Persistent session disables clearing of the client session on connection.
## In order for this option to work you must also set client_id to identify
## the client. To receive messages that arrived while the client is offline,
## also set the qos option to 1 or 2 and don't forget to also set the QoS when
## publishing.
# persistent_session = false
## If unset, a random client ID will be generated.
# client_id = ""
## Username and password to connect MQTT server.
# username = "telegraf"
# password = "metricsmetricsmetricsmetrics"
## Optional TLS Config
# tls_ca = "/etc/telegraf/ca.pem"
# tls_cert = "/etc/telegraf/cert.pem"
# tls_key = "/etc/telegraf/key.pem"
## Use TLS but skip chain & host verification
# insecure_skip_verify = false
## Data format to consume.
## Each data format has its own unique set of configuration options, read
## more about them here:
## https://github.com/influxdata/telegraf/blob/master/docs/DATA_FORMATS_INPUT.md
# data_format = "influx"
## Enable extracting tag values from MQTT topics
## _ denotes an ignored entry in the topic path
[[inputs.mqtt_consumer.topic_parsing]]
topic = "+/+/+/+/+"
## measurement = ""
tags = "family/device/sensor/number/data"
## fields = "_/_/_/_/value"
## [inputs.mqtt_consumer.topic_parsing.types]
##
In portainer create a stack e.g. energy-monitoring:
version: "3"
services:
mosquitto:
image: eclipse-mosquitto
restart: unless-stopped
ports:
- 1883:1883
- 9001:9001
volumes:
- /volume1/docker/energy-monitoring/mosquitto/data:/mosquitto/data/
- /volume1/docker/energy-monitoring/mosquitto/mosquitto.conf:/mosquitto/config/mosquitto.conf
- /volume1/docker/energy-monitoring/mosquitto/mosquitto.log:/mosquitto/log/mosquitto.log
influxdb:
image: influxdb:2.5
restart: unless-stopped
ports:
- 8086:8086
volumes:
- /volume1/docker/energy-monitoring/influxdb2:/var/lib/influxdb2:rw
telegraf:
image: telegraf
environment:
- INFLUX_TOKEN=generate-a-write-token-at-8086
volumes:
- /volume1/docker/energy-monitoring/telegraf/telegraf.conf:/etc/telegraf/telegraf.conf:ro
grafana:
image: grafana/grafana
restart: unless-stopped
ports:
- 3000:3000
volumes:
- grafana:/var/lib/grafana
volumes:
grafana:
Go to the web ui of the shelly and open Internet/Developer settings and enable mqtt to the synology's ip on port 1883.
Use MQTT Explorer to see if topics are published.
Create a new connection and connect to http://influxdb:8086 (docker cares about resolving this name).
{
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": {
"type": "grafana",
"uid": "-- Grafana --"
},
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"target": {
"limit": 100,
"matchAny": false,
"tags": [],
"type": "dashboard"
},
"type": "dashboard"
}
]
},
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 0,
"id": 1,
"links": [],
"liveNow": false,
"panels": [
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"fieldConfig": {
"defaults": {
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "short"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 3,
"x": 0,
"y": 0
},
"id": 9,
"options": {
"colorMode": "none",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"query": "from(bucket: \"energy-monitoring\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r.sensor == \"emeter\" and r.number == \"0\" and r.data == \"voltage\")\n |> last()",
"refId": "A"
}
],
"title": "Spannung A",
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"fieldConfig": {
"defaults": {
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "short"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 3,
"x": 3,
"y": 0
},
"id": 10,
"options": {
"colorMode": "none",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"query": "from(bucket: \"energy-monitoring\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r.sensor == \"emeter\" and r.number == \"1\" and r.data == \"voltage\")\n |> last()",
"refId": "A"
}
],
"title": "Spannung B",
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"fieldConfig": {
"defaults": {
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "short"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 3,
"x": 6,
"y": 0
},
"id": 11,
"options": {
"colorMode": "none",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"query": "from(bucket: \"energy-monitoring\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r.sensor == \"emeter\" and r.number == \"2\" and r.data == \"voltage\")\n |> last()",
"refId": "A"
}
],
"title": "Spannung C",
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"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": [],
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 12,
"x": 9,
"y": 0
},
"id": 13,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"query": "from(bucket: \"energy-monitoring\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> drop(columns: [\"topic\", \"host\", \"device\", \"family\", \"_measurement\"])\n |> filter(fn: (r) => r.sensor == \"emeter\" and r.data == \"voltage\")",
"refId": "A"
}
],
"title": "Spannungen",
"type": "timeseries"
},
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"fieldConfig": {
"defaults": {
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "blue",
"value": null
}
]
},
"unit": "watth"
},
"overrides": []
},
"gridPos": {
"h": 2,
"w": 3,
"x": 21,
"y": 0
},
"id": 15,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"query": "from(bucket: \"energy-monitoring\")\n |> range(start: -1m)\n |> filter(fn: (r) => r.sensor == \"emeter\" and r.data == \"total\")\n |> last()\n |> group()\n |> sum()\n",
"refId": "A"
}
],
"title": "Gesamtverbrauch",
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"fieldConfig": {
"defaults": {
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"unit": "amp"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 3,
"x": 21,
"y": 2
},
"id": 16,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"query": "from(bucket: \"energy-monitoring\")\n |> range(start: -1m)\n |> filter(fn: (r) => r.sensor == \"emeter\" and r.data == \"current\")\n |> last()\n |> group()\n |> sum()\n",
"refId": "A"
}
],
"title": "Strom",
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"max": 40,
"min": 0,
"thresholds": {
"mode": "percentage",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "#EAB839",
"value": 60
},
{
"color": "red",
"value": 80
}
]
},
"unit": "amp"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 3,
"x": 0,
"y": 3
},
"id": 6,
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"query": "from(bucket: \"energy-monitoring\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r.sensor == \"emeter\" and r.number == \"0\" and r.data == \"current\")\n |> last()",
"refId": "A"
}
],
"title": "Strom A",
"type": "gauge"
},
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"max": 40,
"min": 0,
"thresholds": {
"mode": "percentage",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "#EAB839",
"value": 60
},
{
"color": "red",
"value": 80
}
]
},
"unit": "amp"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 3,
"x": 3,
"y": 3
},
"id": 20,
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"query": "from(bucket: \"energy-monitoring\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r.sensor == \"emeter\" and r.number == \"1\" and r.data == \"current\")\n |> last()",
"refId": "A"
}
],
"title": "Strom B",
"type": "gauge"
},
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"max": 40,
"min": 0,
"thresholds": {
"mode": "percentage",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "#EAB839",
"value": 60
},
{
"color": "red",
"value": 80
}
]
},
"unit": "amp"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 3,
"x": 6,
"y": 3
},
"id": 21,
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"query": "from(bucket: \"energy-monitoring\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> filter(fn: (r) => r.sensor == \"emeter\" and r.number == \"2\" and r.data == \"current\")\n |> last()",
"refId": "A"
}
],
"title": "Strom C",
"type": "gauge"
},
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"fieldConfig": {
"defaults": {
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"unit": "watt"
},
"overrides": []
},
"gridPos": {
"h": 3,
"w": 3,
"x": 21,
"y": 5
},
"id": 17,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"query": "from(bucket: \"energy-monitoring\")\n |> range(start: -1m)\n |> filter(fn: (r) => r.sensor == \"emeter\" and r.data == \"power\")\n |> last()\n |> group()\n |> sum()\n",
"refId": "A"
}
],
"title": "Verbrauch",
"type": "stat"
},
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"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": "smooth",
"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": "watt"
},
"overrides": []
},
"gridPos": {
"h": 18,
"w": 24,
"x": 0,
"y": 8
},
"id": 4,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"hide": false,
"query": "import \"interpolate\" \nfrom(bucket: \"energy-monitoring\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> drop(columns: [\"topic\", \"host\", \"device\", \"family\", \"_measurement\"])\n |> filter(fn: (r) => r.sensor == \"emeter\" and r.data == \"power\")",
"refId": "B"
},
{
"datasource": {
"type": "influxdb",
"uid": "PpfPwsd4k"
},
"hide": true,
"query": "import \"interpolate\" \nfrom(bucket: \"energy-monitoring\")\n |> range(start: v.timeRangeStart, stop: v.timeRangeStop)\n |> drop(columns: [\"topic\", \"host\", \"device\", \"family\", \"_measurement\"])\n |> filter(fn: (r) => r.sensor == \"emeter\" and r.data == \"power\")\n |> yield(name: \"individual\")\n |> interpolate.linear(every: 1s)\n |> aggregateWindow(every: 1s, fn: mean)\n |> group(columns: [\"_time\"])\n |> sort(columns: [\"_time\"])\n |> sum()\n |> group()\n |> yield(name: \"total\")",
"refId": "A"
}
],
"title": "Power [W]",
"type": "timeseries"
}
],
"refresh": "5s",
"schemaVersion": 37,
"style": "dark",
"tags": [],
"templating": {
"list": []
},
"time": {
"from": "now-1h",
"to": "now"
},
"timepicker": {},
"timezone": "",
"title": "Energy Monitoring",
"uid": "SYt1W8O4z",
"version": 15,
"weekStart": ""
}