How do I combine columns in a table in Looker Studio so that all the data is in one column?

[julief]

I have the following table. 

I want to combine the columns Adjusted Area Field 1, 2, and 3 into one combination column and sum the results. If done correctly, the results should look as follows:

How do I do this in Looker Studio?

[shijithpulikkal]

Hi,

you can use a new calculated field  using this  COALESCE(Adjusted Area Field 1,Adjusted Area Field 2,Adjusted Area Field 3)  and name it Combination Column

Shijith Pulikkal

[julief]

Thanks @shijithpulikkal. I have an additional caveat I am now finding and I am hoping you can help. 

When the data has a non null value in Adjusted Area Field 1 and Adjusted Area Field 2, when I coalesce them, I want the count to count .5 for each area. So for instance, with Deliver in Adjusted Area Field 1 and Build in Adjusted Area Field 2, I want to add .5 to the Deliver total AND .5 to the Build total when I combine everything. Do you know how to do this?

[shijithpulikkal]

Hi,

COALESCE - Returns the first non-missing value found in a list of fields. please ref below link 

https://support.google.com/looker-studio/answer/10522032?hl=en

if Adjusted Area Field 1 and Adjusted Area Field 2 both have non-null values.. it will only pickup the first value.. which is Adjusted Area Field 1

i dont think other calculation is possible