5 Replies Latest reply on May 2, 2017 6:07 AM by Marc Metz

    Inner Join

    Marc Metz

      Hi guys,

       

      working on surveys, I use this blog instructions: Getting Survey Data “Just So” using Tableau 10.x – Data Revelations 


      What I did was to pivot all my survey results (Q1, Q2, Q3 etc.). With an Question Helper, I make sure I can allocate what Q1, Q2 etc. actually means. While this works perfect in general I have one problem with Check-all-that-applies questions. They are structured the way Q6-1, Q6-2, Q6-3 etc. My question helper however only has Q6, as all are the same question, just different answers.

       

      This is the reason my Inner Join doesn't work. Q6-1, Q6-2 etc. are just excluded, as there is no match to Q6 in the question helper. Do you have any best practice how to solve this?

       

      Screen Shot 2017-05-02 at 11.30.06.png

       

      Screen Shot 2017-05-02 at 11.34.26.png