1 Reply Latest reply on Feb 27, 2018 8:40 AM by Jim Dehner

    Splitting a Dimension into sub-dimensions

    Shaun Fourie

      Hi, I hope that someone can help me out. Perhaps this is an easy thing to do, I am still quite new to Tableau.

       

      I have data that I am pulling into Tableau from MySQL but the data's format needs some adjusting before I can start analysing.

       

      Essentially, I am working with Survey data and at the moment all of my questions are in one collum and the responses in a separate collum.

       

      I want to know if there is a way in which I can split the questions each into their own dimension and / or measure so that I can use them individually in my analysis. I know that I would be able to work around the issue but still be limited if I filter on the questions etc. but this is not a solution that will work long term.

       

      I have attached the 2 columns that I am talking about. I will still setup aliases etc. for the survey questions and results but need to split the question collum.

       

      Thanks.