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



      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.