5 Replies Latest reply on Sep 27, 2019 9:40 AM by Bryan Pon

    Creating chart with multiple dimensions from normalized survey data

    Bryan Pon

      I've tried searching the forums, but not quite sure what I'm event trying to ask. My sense is this is a basic conceptual misunderstanding/gap that I have.

       

      I have survey data that is formatted such that each row has a respondent's answer to a question.  We can say the columns are: respondent id, question, response. 

       

      idquestionresponse
      123carhonda
      123marriedyes

       

       

      I can filter the data to easily create views on any one question (e.g., how many respondents have a Honda). But I can't figure out how to combine multiple questions into a single view (e.g., how many respondents with a Honda are married).

       

      I made a simple example workbook, attached. In this example what I'd like to do is show how many of the respondents are married by applying the color mark to the bar chart.

       

       

      Thanks!