2 Replies Latest reply on Jun 13, 2016 11:00 PM by Xiaolun Zhang

    Addressing Check-all-that-apply responses by Tableau

    Xiaolun Zhang

      Hi, I wander if there's a way I can reshape the data by Tableau other than Excel. I know when it connects to a data source, I can make a pivot value. But what if I have a lot of check-all-that-apply questions on the same data source? I tried but it accumulated the response to second check-all-that-apply question to the first one, which means it added up two different questions response to one pivot value. Is there any way to address that?

      And by the way when I pivot the data, the number of records also multiplied. I have a responser ID for each person who took the survey. How to address that when I'm doing some analysis? Otherwise the number is just not right.

       

      Thank you!