I have a google survey with multiple answers that resulted in data on a google sheet to have columns with comma-separated values
col1
A
A,B
A,C
B,C
C,D
I want one chart on google looker studio that turns counts of A, count of B count of C and count of D.
I have tried this solution already and it didn't not work CASE WHEN CONTAINS_TEXT(col1, "A") THEN "A" WHEN CONTAINS_TEXT(col1, "B") THEN "B" WHEN CONTAINS_TEXT(col1, "C") THEN "C" WHEN CONTAINS_TEXT(col1, "D") THEN "D" END
The chart is to be controlled by other demographic columns, like gender, age group, Location, etc..
