7 Replies Latest reply on Aug 24, 2012 12:29 PM by Nathan Brown

    Those pesky date functions

    Nathan Brown

      The way Tableau handles date functions continues to elude me.. Here is a set of area charts on Seattle crime rates for the years 1985- 2011. For some reason, Tableau sees the "Year" fields (which simply progress from 1985 to 2011) in terms of specific dates in 1905. I've tried saving the field in the underlying Excel file as "Date" as well as "Number", but it doesn't seem to matter-- after a refresh, "view data" in Tableau still shows the 1905 dates. I just want a simple sequence of years running from 1985 through 2011.

       

      A second question: How can I tell Tableau to assign specific colors to each field/area in the area chart? I seem to only get the opportunity to set up a gradient, which is not appropriate.

       

      Thanks!