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/10 22:51] – 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. | ||
- | < | + | < |
from(bucket: | from(bucket: | ||
|> range(start: | |> range(start: | ||
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.1646949081.txt.gz · Last modified: 2022/03/10 22:51 by illu