Convert null values to 0 in tables Grafana

Hi Community,
I created a table with two columns and used “Add field from calculation” to combine (sum) those two columns into a “Total” column.
However, if one column has a null value, the “Total” column shows NaN. I want null values to be converted to 0 so that the “Total” column is calculated as Value 1 + Value 2 (null → 0) = Value 1.
I tried using data mapping, formatting fields to numbers, or adding or vector(0) in the query… but it didn’t work. Null values can be displayed as 0 in the table, but the “Total” column still shows NaN (I think it maps null to a string “0” instead of a number).


Thanks

I’m sorry,
I use Convert Fields Type before “Add Fields From Calculation”, It’s OK,

1 Like