I’m upgrading my environment and replacing my old InfluxDB 1.8 with 2.7.3 and am learning there’s a good bit of a learning curve. I’ve got almost everything squared away, but am having an issue with a single field aliasing, all others are working just fine and I suspect its the math in the map function.
from(bucket: "sensors")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == "mqtt_consumer")
|> filter(fn: (r) => r["_field"] == "office_temperature")
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> map(fn: (r) => ({ r with _value: float(v: r._value) *9.0/5.0 + 32.0, _field:"Temperature"}))
|> yield(name: "mean")
Trying to simply rename the field variable to read Temperature but with this singular field it only renames a portion.
Any help would be appreciated.
