Expand my Community achievements bar.

SOLVED

Week 0 in DataWarehouse

Avatar

Level 3

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

1 Accepted Solution

Avatar

Correct answer by
Level 3

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 solution in original post

2 Replies

Avatar

Correct answer by
Level 3

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?  

Avatar

Employee Advisor

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?