Hi,
I have a problem with the transformation ‘Config from query results’ where I don’t know what to do. What I want to do is to dynamically write the ‘max’ value of the multiple gauges using the transformation. However, I have that with some transformations 2 fields are suggested and with some only one field. Why is that? I should only have one field to choose from, because I want to use the other one for another gauge. I use Influxdb as my database.
what I sometimes get:
what I want:
my influx query to get the gauge-values:
from(bucket: “CM”)
|> range(start: -5m)
|> filter(fn: (r) => r[“_measurement”] == “Schwingung”)
|> filter(fn: (r) => r[“Anlage”] == “UWP”)
|> filter(fn: (r) => r[“Bereich”] == “KKF”)
|> filter(fn: (r) => r[“Standort”] == “HA”)
|> filter(fn: (r) => r[“Unit”] == “${Messaufgabe}”)
|> filter(fn: (r) => r[“VSE_Identifier”] == “${Messstelle}”)
|> filter(fn: (r) => r[“_field”] == “Value”)
|> map(fn: (r) => ({ r with _value: if r[“Unit”] == “m/s” then r._value * 1000.0 else r._value}))
|> aggregateWindow(every: 10s, fn: last, createEmpty: false)
|> yield(name: “last”)
my influx query to get the max-values for the transformation:
from(bucket: “CM”)
|> range(start: -5m)
|> filter(fn: (r) => r[“_measurement”] == “Schwingung”)
|> filter(fn: (r) => r[“Anlage”] == “UWP”)
|> filter(fn: (r) => r[“Bereich”] == “KKF”)
|> filter(fn: (r) => r[“Standort”] == “HA”)
|> filter(fn: (r) => r[“Unit”] == “${Messaufgabe}”)
|> filter(fn: (r) => r[“VSE_Identifier”] == “${Messstelle}”)
|> filter(fn: (r) => r[“_field”] == “Damage”)
|> map(fn: (r) => ({ r with _value: if r[“Unit”] == “m/s” then r._value * 1000.0 else r._value}))
|> aggregateWindow(every: 6h, fn: last, createEmpty: false)
|> yield(name: “last”)
: