6 Replies Latest reply on May 4, 2012 11:45 AM by Alex Kerin

    Can tableau use year dates? (without month or day)

    Jeremy Coughlin

      Hi,

       

      I have data that is already aggregated to the year level. Can Tableau use this or is a transformation necessary?

       

      My data looks like:

       

      Year     Demand     Sales

      2008     12               5

      2009     13               6

      2010     13               7

      2011     15               9

       

      Every way I try to use this data turns out wrong. I've even tried reformatting the dates in excel to be 1/1/2008 just to try and work with Tableau but now it gives me a '*' when I use it on a visualization. 

       

      I have really liked Tableau in the past but the way it handles dates is very painful.

       

      Thanks,

       

      Jeremy