@iobroker2001
Grafana Plugin = Operato Windrose
InfluxDB Query für Flux:
from(bucket: "iobroker")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == "Netatmo_Wind_Angle" or r["_measurement"] == "Netatmo_Wind_Speed")
|> filter(fn: (r) => r["_field"] == "value")
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> pivot(rowKey: ["_time"], columnKey: ["_measurement"], valueColumn: "_value")
|> rename(columns: {Netatmo_Wind_Angle: "wind_direction", Netatmo_Wind_Speed: "wind_speed"})
|> keep(columns:["_time", "wind_direction", "wind_speed"])
|> yield(name: "last")