How to put 0 as result if there is no results

InfluxDB 2
,
1

When my query return no results, i would like to put 0 instead of nothing. Here’s my query:

from(bucket: “Bacnet_Network”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == “048_STEM”)
|> filter(fn: (r) => r[“room_system”] == “AHU16”)
|> filter(fn: (r) => r["_field"] == “value”)
|> last()
|> filter(fn: (r) => r.sensor =~ /DMP/ and r._value <= 75.0)
|> group()
|> count()
|> map(fn: (r) => ({r with _dmp_max: float(v: r._value) / 7.0 * 100.0}))
|> mean(column: “_dmp_max”)

Thx!

2

maybe this help:

https://stackoverflow.com/questions/67287035/influxdb-2-0-flux-how-to-return-0-instead-null

4

@chrismec Thx a lot! Works like a charm!

Merry Christmas and happy new year! :v: