2 Replies Latest reply on Dec 3, 2012 10:52 AM by Ari Parritz

    Create category counts in two dimension tables

    Ari Parritz

      Hello,

       

      I'm converting survey response data into a tableau dashboard.  The survey is fairly simple: respondents are given the same four qualitative answer choices for about 10 questions.  I'd like tableau to list the questions vertically and have the four response options appear horizontally as columns.  I'd like the data points to be the count of each response option for each question.

       

      In the attached workbook, i've shown a sample of the survey data (A1:E5), as well as what i'd like the tableau summary output to look like (A7:C11).

       

      Can someone please let me know the proper way to setup the data fields in tableau?  I've been experimenting for the past couple hours and I cannot get the data to appear properly.

       

      Thanks!!