Combined Column in Google Data Studio

Question

I am having trouble combining separate columns with null values into one.

The example table I have contains values like so

I want to write the statement such that I get a column that contains all the values.

I have tried a few different ways but I am still getting nulls in my combined column.

The latest attempt was :

CASE 
WHEN Col A IS NOT NULL THEN Col A
WHEN Col B IS NOT NULL THEN Col B
WHEN Col C IS NOT NULL THEN Col C
END

I thought this would work because GDS's page on case statements says it returns the first true value but my result is all nulls.

Any help is appreciated.

score 0 · Accepted Answer · answered Jan 21 '21 at 10:40

It can be achieved by incorporating the NARY_MAX function below, which ensures that NULL values are treated as the numeric literal 0:

NARY_MAX(Col A, 0) + NARY_MAX(Col B, 0) + NARY_MAX(Col C, 0)

1 Answers1