I have a date dimension from year down to day. I need a rolling 8 week level to show the last 8 weeks in grouped form. When I create it just like I did the last 7 days I get 10 groupings for 8 weeks, when i change it to 7 I get 8.
Relative Time Tab
Custom
N-Period Running Total
Number of periods 7
Period Week
Context Year
Target and Context 0
Interesting.. What version of Transformer are you using?
Thanks
Charlie