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?
5 answers
Can you Create Join Calculation?
If so, connect QuestionID1 with created join calculation: LEFT([QuestionID2],2)
That will capture only Q6 in both Question ID1 and QuestionID2
