Hey, I have two metrics (power from meter and power from PV). I want to add them, but one (from PV) when there is no sun is null. So in this case I need sum power from meter and 0. I’ve created below code, that works when both values are visible: from(bucket: "autogen") |> range(start: v.time…

I believe you can use the fill() function: fill() function | Flux 0.x Documentation fill() replaces all null values in input tables with a non-null value. |> fill(column: "power_from_pv", value:0)

Sum of 2 values which one sometimes is null/empty

Fluxlang

rickspencer3 November 24, 2021, 11:00pm 2

I believe you can use the fill() function:

|> fill(column: "power_from_pv", value:0)

1 Like

Topic		Replies	Views
Sum two measurement values InfluxDB 2 influxdb , grafana , flux	3	2192	March 20, 2023
Count() null if zero measurements found Fluxlang	3	1307	August 16, 2019
Flux Query: Join by time and fill null-values with the last value influxdb , query , flux	6	57	February 12, 2025
Fill(none) in flux to remove lines with null values InfluxDB 2 flux	3	7654	July 8, 2021
Multiply two measured values with the map-funktion Fluxlang query	1	11	February 18, 2025

Sum of 2 values which one sometimes is null/empty

Related topics