Skip to main content
davidb98884514
davidb98884514
Level 3
Oct 16, 2015 2:26 AM UTC
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
    Oct 16, 2015 2:26 AM UTC

    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 in thread

    2 replies

    Gigazelle
    Adobe Employee
    GigazelleAdobe Employee
    Adobe Employee
    Oct 16, 2015 2:26 AM UTC

    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
    ecarpe15Accepted solution
    Level 3
    Oct 16, 2015 2:26 AM UTC

    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
      Terms & ConditionsAccessibility statement

      Loading footer...