8 Replies Latest reply on Sep 17, 2013 12:59 PM by Wilson Becker

    Assigning a date range to week number?

    Wilson Becker

      Hello everybody- quick question! I'd be really happy if you can help me figure it out

       

      My data source has four columns to identify time--> Year, Month, Week, and Date

       

      Every row has a year, a month, and a week.. but only a couple rows have a date

       

      Here's what my setup looks like so far:

       

      setup.png

       

      What I'd like to do is assign a date range to each week, i.e. February Week 1 = 2/3/13 - 2/9/13, etc.

       

      I've already looked at http://kb.tableausoftware.com/articles/knowledgebase/show-week-instead-week-number

      which was helpful, but not exactly what I'm looking for.

       

      The only reason I need a date rage for each week is because only a few of my data rows have an exact date associated with them. Eventually, I'll want to roll those exact dates up into their respective weeks. I assume there will need to be some case statement using datediff() to determine which week an exact date belongs to.

       

      Like I said, any help would be greatly appreciated! I'm still very new to Tableau

       

      Thanks