4 Replies Latest reply on Dec 20, 2019 1:24 PM by Jim Dehner

    NEED HELP! Multiple Answer Question on a survey

    ignacio tribu

      Hey Tableau community,

       

      I am currently working on a worksheet and im having some difficulties.

       

      We are trying to analyze the answers of a survey we did. My problem is with a question that allowed multiple answers.

       

      How can i express these answers in a table/graph?

       

      What i have tried so far:

       

      If CONTAINS([dimension name)],'Casual')  THEN "Casual"

          ElseIf Contains([dimension name)],'Clasico')  THEN "Clasico"

          ElseIf Contains([dimension name)],'Elegante')  THEN "Elegante"

          ElseIf Contains([dimension name)],'Fitness')  THEN "Fitness"

          ElseIf Contains([dimension name)],'Hypebeast')  THEN "Hypebeast"

          ElseIf Contains([dimension name)],'Rock')  THEN "Rock"

          ElseIf Contains([dimension name)],'Skater')  THEN "Skater"

      ELSE "error"

      END

       

       

      The problem with this formula is that it works in the order we see above. For example, If my answer was "Casual" and "Fitness", it includes me on casual as it is the first line but wont include me on "Fitness".

       

      Hope someone can help. Ask for more information if you need/don´t understand.

       

      Thank you!