3 Replies Latest reply on Dec 7, 2018 8:33 AM by William Rielly

    Creating word cloud from survey responses

    Manil Wagle

      I have a survey question where we have asked people given the option, where they would like to eat? Respondents were given 5 options, from first choice to fifth choice.

       

      I am trying to create word cloud of the responses and see them as percentage. Currently I can easily create work cloud by pivoting all the choices with (First to 5th choices).

       

      But I found a problem here, when I pivot in such a way, I am getting percentage as total number of choices (records) regardless of respondents.

       

      For example, I am getting 10.95% for Keg in wordcloud where as if I just look at first choice, I get 16.02%.

       

      Below is the short example:

      Respondent

      First Choice

      Second Choice

      Third Choice

      1

      apple

      cherry

      grapefruit

      2

      banana

      apple

      NA

      3

      apple

      oranges

      cherry

      4

      apple

      cherry

      NA

      5

      apple

      banana

      NA

      Apple

      Tableau Pivot way

      5/15:  40.00%

      If I want to know, how many people wanted apple: 5/5

      100.00%

      As 100% of the people who filled the survey wanted apple

       

      I have also attached sample survey file.

       

      I would really appreciate if anyone could hep me to solve this calculation problem in Tableau