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

    Combining comma separated values calculated fields


      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"


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



      Thanks in advance for any help!