1 Reply Latest reply on Dec 4, 2017 10:29 AM by Deepak Rai

    Combining comma separated values calculated fields

    erik.bernheim

      I have data coming from survey software in the following format

       

      Multiple Choice Group
      Apple, Banana, Grape
      Pear, Mango, Apple
      Apple, Banana
      Mango, Grape

       

       

      I'm trying to get it into a chart like this

      Screen Shot 2017-12-04 at 1.10.43 PM.png

       

      I created calculated fields for each value like this

      IF CONTAINS([Multiple Choice Group],"Apple")

      THEN "Apple"

      END

      I don't know how to combine these together to create a chart with each representing one column.

       

       

      Thanks in advance for any help!