Influxdb 2.0 Flux - How to return 0 instead null

Question

I want to count amount of values that are greater than specific value. Data:

from(bucket: "bucket name")
    |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
    |> filter(fn: (r) => r._value > 35)
    |> count()

If there are no values in the processing data range that are greater the specified value than the influx returns nothing (no data).

score 3 · Accepted Answer · edited May 05 '21 at 14:13

3

Solution with a little trick... Instead of filter() and count() - need to use map() and sum()

from(bucket: "bucket name")
     |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
     |> map(fn: (r) => ({ r with _value: if r._value 35 then 1 else 0 }))
     |> sum()

edited May 05 '21 at 14:13

Piqvi

5
1

answered May 05 '21 at 14:08

Amerousful

2,292
1
12
26

Bencho Naut · Answer 2 · 2023-03-11T07:47:03.167

Failing: InfluxDB2 null as zero (float())

Issues appeared with float values ,

where a virtual instance not running for a (missing) timeframe

appeared as constantly-cpu-consuming...

Influxdb connects series without 0 ,here a cpu graph with missing timeframes

fill() only works on integers,
non-existing datapoints can't be if-catched by value (...)
aggregateWindow() finally helped

Solution: InfluxDB2 null as zero (float())

from(bucket: "sys")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r._measurement == "docker_cpu_percent" )
//  |> window(every: 5m, period: 5m, createEmpty: true)
  |> aggregateWindow(every: 5m, fn: mean, createEmpty: true)
  |> map(fn: (r) => ({
      r with
      _value: if exists r._value then float(v: r._value) * 1.0  else 0.0
    })
  )

Resources

You might refer to

Influxdb 2.0 Flux - How to return 0 instead null

2 Answers2

Failing: InfluxDB2 null as zero (float())

Solution: InfluxDB2 null as zero (float())

Resources