5 Replies Latest reply on Jun 14, 2018 1:07 PM by Brian Vu

    Splitting 53 weeks across two years

    Brian Vu

      Hi all,

       

      I'm attempting to make a weekly value tracker and can't seem to get over this hurdle of splitting the 53rd week across two years:

      Tableau_1.PNG

       

      Ideally I would want to see:

      YearWeek
      WeekStartWeekEnd
      20155312/28/201512/31/2015
      201611/1/20161/3/2016
      201621/4/20161/10/2016

       

      So that the first week of every year may have 1 - 7 days. This particular set-up starts weeks on Mondays.

       

      Similarly for 2016-2017...

      Tableau_2.PNG

      YearWeek
      WeekStartWeekEnd
      20165312/26/201612/31/2016
      201711/1/20161/1/2016
      201721/2/20171/8/2017

       

      From here I would be able to sum the # of records and divide over the number of days to get a Records/Day average. Users would be able to select which years and weeks they're interested in.

       

      I've looked at this post which seems to describe exactly what I need - and sounds likes its basic Tableau functionality - but I have not been able to get it to work: Week in, week out, Tableau - Clearly and Simply

       

      Unfortunately I can't post a workbook because it contains proprietary company data.

       

      Thanks in advance.