1 of 1 people found this helpful
The following KB provides information on how to deal with survey data:
It sounds like your data needs to be reshaped. The following 2 knowledge base articles provide information on how to set up your Excel file (if using Excel) and includes a reshaper tool:
Hope this helps!
Thanks for the response! I'd already put in a lot of time making aliases for various dimensions so was looking for a work-around to avoid unpivoting. Ended up creating an IF-based calculated field that did the trick.
Hi Jane, this is one of the issues that i was struggling with as well. How did you formulate your IF calculation without making the MA columns mutually exclusive?
(also have contributed a related idea here- http://community.tableau.com/ideas/1731 do vote if you find it useful )
Yes, I agree that composite filters would be a great feature for Tableau! In my dataset, there was a way to roll-up the options into 4 main buckets that were mutually exclusive, so my IF calculation did assume mutual exclusivity.
Sorry I couldn't be more help!