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

Week 0 in DataWarehouse

  • October 16, 2015
  • 2 replies
  • 1413 views

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.
    Best answer by ecarpe15

    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?  

    2 replies

    E
    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?  

      Gigazelle
      Adobe Employee
      GigazelleAdobe Employee
      Adobe 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?

      Terms & ConditionsAccessibility statement

      Loading footer...