count distinct and how to create a new graphic or count field

[mab3]

Hello!

I'm creating a dashboard from a google sheets' data set. This data set is a result of a research using google forms.

some of the answers were multiple-choice questions. their answers allowed for several others, which are grouped together separated by commas in the same record.

I want to create a graph that identifies each of the multiple choice options and groups the answers, allowing them to be counted.

I have some pictures below to illustrate

 the graphic is using another google sheet, and not the same data set

[Mehdi_Oudjida]

@mab3 

Here an article describing how to split delimiter-separated values to singles values with consistent related metrics.

https://how.withlookerstudio.com/custom-reports/20211105-how-to-split-comma-separated-values-to-sing...

I hope it helps.

Mehdi