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:




      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