Week 0 in DataWarehouse | Community
Skip to main content
davidb98884514
davidb98884514
Level 3
October 16, 2015
Solved

Week 0 in DataWarehouse

Can anyone explain why I'm getting a Week 0 in Data Warehouse when running a weekly granularity report? Thanks!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    ecarpe15Accepted solution
    Level 3
    October 16, 2015

    Your week zero is probably the first few days at the beginning of the year and is considered week 52 in the prior year.  Week 1 in 2015 starts on 1/4/2015, week zero is probably 1/1 thru 1/3.  Is the data for week zero look to be partial or 3/7ths of a normal week?  

    View reply

    2 replies

    ecarpe15Accepted solution
    Level 3
    October 16, 2015

    Your week zero is probably the first few days at the beginning of the year and is considered week 52 in the prior year.  Week 1 in 2015 starts on 1/4/2015, week zero is probably 1/1 thru 1/3.  Is the data for week zero look to be partial or 3/7ths of a normal week?  

    Translate
      Gigazelle
      Gigazelle
      Employee
      October 16, 2015

      Hi David, can you provide more details on how your data warehouse report is constructed? I'm not looking for numbers per se, but what breakdowns/metrics are you using?

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...