I have attached three files;
Sample 1 tableau workbook - a working dashboard which is what i'm aiming to achieve
Sample 1 excel file: dummy data used to build the tableau dashboard
Sample 2 excel file: actual data which I need to turn into the dashboard in sample 1.
The difference between the two is that (1) is single entry fields and (2) contains multi entry fields.
The multi-select fields in sample 2 are killing me. Ive tried all kinds of things including splitting into numerous files in tableau prep, various pivot arrangements etc.
I'm starting to think there is no (relatively) simple way to get my data to perform as in sample 1.
Any help or pointers would be greatly appreciated.
Have you seen this post by Steve Wexler? https://www.datarevelations.com/using-tableau-to-visualize-survey-data-part-3-dealing-with-multiple-memberships-for-resp…
Steve is the master of survey data so I think this post could be very helpful here.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...