1 Reply Latest reply on Nov 10, 2018 12:50 PM by Mavis Liu

    Combing Date Dimensions

    Incoming Thomas

      Blank

        • 1. Re: Combing Date Dimensions
          Mavis Liu

          Hi John,

           

          I'd recommend transposing your data, in Tableau desktop you can do this using the pivot option. Highlight all the columns you need to transpose, then right click and select pivot:

           

          2018-11-10_20h47_36.png

           

          Then use the split function to get the year into a column:

           

          2018-11-10_20h48_32.png

           

          Then convert it to a date field:

           

          2018-11-10_20h48_44.png

           

          Now you can use this date field:

           

          2018-11-10_20h48_59.png

           

          Thanks,

           

          Mavis