title: Google Data Studio piechart from column with multiple values per cell
body: <p>I have an excel spreadsheet from a Questionnaire. One of the questions was in checkbox format. The result of this question are held in a single column, and where the user has selected more that one answer, the answers are separated by comma's.</p>
  
  <p>What devices do you own?  Mobile, PC, Laptop, Tablet</p>
  
  <p>So in a single cell I get 'Mobile,PC' when these two are selected.</p>
  
  <p>I am using Google Data Studio to visualise the data, but stuck on how to create a graph that shows all the values individually.</p>
  
  <p>At the minute I get a combination for every value. So a value of 1 for 'Mobile,PC' rather than a value for 1 'PC' and '1'Mobile.</p>
  
  <p>Google Data Studio doesn't allow countif statements, so a bit lost.</p>
  
  <p>I have tried to TRIM, COUNIF and REGEX but none have worked. </p>
  
  <pre><code>Count(REGEXP_MATCH(Device, "PC"))
  </code></pre>
  
  <p>I'm a bit lost on this, tried so many combinations. If someone can put me on the right track I would be very grateful</p>