1 Reply Latest reply on Jan 28, 2019 9:07 AM by Ken Flerlage

    Tricky survey data

    james.abbott.1

      Hi all,

       

      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.

       

      Thanks!