2 Replies Latest reply on Mar 24, 2016 11:27 AM by Zack Gorman

    Why is it missing Marks?

    jon rios

      pretty straight forward (i think)  i can see there is sales data for 2011 in the first week but it doesn't appear as a mark ... help investigating or explaining why?

       

        • 1. Re: Why is it missing Marks?
          Kenneth McBride

          Hey Jon,

           

          Technically week 1 for 2011 is Saturday, January 1st and week 2 starts the next day.

           

          This might help you a bit: http://kb.tableau.com/articles/issue/getting-complete-week-data-across-two-years

           

          Ken

          3 of 3 people found this helpful
          • 2. Re: Why is it missing Marks?
            Zack Gorman

            Hi Jon,

             

            Per usual, Ken is absolutely right. It's unfortunately working as intended. If you're wanting to look at full weeks starting with the first of the year, here is a calculation that would help with that. Just replace [Date] with your date field, and use this calculation as you would use "week number"

            if datepart('year', [Date])/4 = INT(DATEPART('year', [Date])/4)

            then

            (if DATEDIFF('day', DATETRUNC('year', [Date]), [Date]) <=365 then

            floor(DATEDIFF('day', DATETRUNC('year', [Date]), [Date])/7)+1

            else null end)

            else

            (if DATEDIFF('day', DATETRUNC('year', [Date]), [Date]) <=364 then

            floor(DATEDIFF('day', DATETRUNC('year', [Date]), [Date])/7)+1

            else null end)

            END

             

            Hope this helps,
            Zack

            1 of 1 people found this helpful