4 Replies Latest reply on Oct 15, 2018 8:44 PM by Mikey Michaels

    formatting excel data before loading into Tableau

    Mikey Michaels

      Hi All,

      I'm having some tough times trying to get the attached data set into Tableau.

      If you look at column E - "MTD Pre-Previous Year FY 2018 Nov" - you will see this field contains a data - "2018 Nov".  I would like to be able to create a date field based off of this column.

      Is there an easy way to "normalize" this data in Tableau? I'm picturing something like the chart below.

       

      THanks!

      Mikey