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

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

    clay.kitchens

      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)

      two-line-chart.png

       

      Chart 2 (from Tableau)

      two-charts.png