4 Replies Latest reply on Nov 13, 2013 3:25 PM by Susan Baier

    Analyzing Questionnaire Data

    kevin.robell

      I have a large questionnaire that has mostly string data (Y,N) that I am trying to run through Tableau. There is skip logic built in that is creating some challenges regarding the format of the data set. AFter the top level question there is the potential to answer between 2 and 5 additional questions. Obviously not everyone answers these additional questions. Since Tableau recognized the string data as dimensions (example below) (No of Records is the metric/measure) I am unable to display in a crosstab or bar chart without Tableau displaying (the count) as hierarchical.

       

      IDQuestion_1Question_1aQuestion_1bQuestion_2Question_2aQuestion_2b
      111YNBlank =null/not answered2005
      222NYN2009
      333YYNYN2011

       

      What I am trying to do is to visualize the sum of each of the questions on an axis. To do this would I have to convert each of the dimensions to a measure (say count)?

       

      Apologies for any confusion. Any feedback is much appreciated.