4 Replies Latest reply on Mar 28, 2014 11:12 AM by clay.kitchens

    Change month data type to "Date" without a year value?


      Hi, all,

      I'm a new Tableau user and I need to create a two line chart with monthly averages.  The records are monthly temperature averages over a period of time and do not have specific years associated with them.  How can I make Tableau combine the two lines (Chart 1) into one chart, instead of two separate charts (Chart 2) and make Tableau read the month as a date instead of a string?  Thank you in advance!


      Chart 1 (from Excel)



      Chart 2 (from Tableau)