homeautomatisation:influxdb:examples_influxdb
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
homeautomatisation:influxdb:examples_influxdb [2022/03/11 21:40] – illu | homeautomatisation:influxdb:examples_influxdb [2022/03/11 22:24] (current) – illu | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | |||
+ | ====== Last value for snapshot ====== | ||
+ | |||
get only the last value from iobroker shelly power, if its none in range, fill with previous value. | get only the last value from iobroker shelly power, if its none in range, fill with previous value. | ||
< | < | ||
Line 12: | Line 15: | ||
{{: | {{: | ||
+ | |||
+ | |||
+ | ====== Integral for Watt hours / from W to Wh ====== | ||
+ | |||
+ | < | ||
+ | from(bucket: | ||
+ | |> range(start: | ||
+ | |> filter(fn: (r) => r[" | ||
+ | |> filter(fn: (r) => r[" | ||
+ | |> integral(unit: | ||
+ | </ | ||
+ | |||
+ | {{: | ||
+ | |
homeautomatisation/influxdb/examples_influxdb.1647031225.txt.gz · Last modified: 2022/03/11 21:40 by illu