7 Replies Latest reply on Nov 20, 2018 4:59 AM by Mohamed Hersi

    Best Formats for Dates (Year, Quarter, Month) in Data Source

    Mohamed Hersi

      Dear All,

       

      I have had issues recently whereby my data source has Month just entered as Jan, Feb, Mar etc. This has prevented me from creating a Monthly Line Chart because Month is not formatted as DATE. Now I am seeking your advice on the best formats that I can apply in my Excel Data Source before I connect to Tableau?

       

      Is there a better way to add such columns into my data source? I need to analyze my data by Year, Quarter and Month.

       

      Below is a picture of the look of my current data source columns for Year, Quarter and Month.

       

      Formatting Year, Quarter, Month as DATES Inside Excel Data Source.PNG

       

      Regards

      Mohamed