I'm trying to change a null value to 0 to display phone conversions with days in a Bar chart.
That means, if I don't have a phone conversion in a day, the value will be 0.
But nothing works, if I don't have phone conversion the value becomes null.
Can you help me?
I used: CASE WHEN IS NULL THEN 0 ELSE END
and: NARY_MAX (,0)
Any solutions?
CodePudding user response:
So NARY_MAX(<field/metric>,0)
has been working for me in the past to use fields / metrics that can potentially be null
in a calculation. Suddenly it stopped working, no idea why.
What seems to work, however, is IFNULL(<field/metric>,0)
.
CodePudding user response:
not sure what your data source is, but if it is in excel or google sheets I would write a quick IF function to use as the data reference
say you have the values in column A, in column B write =IF(A2="",0,A2)