Question:
hello,
we have req to show the qty's in weekly buckets for the curent month
and then in months..
i was thinking we should create a variable that fills the week1 week2 week3 week 4 and then month 2 month3 month4 month 5 and month 6.
we only need 6 months..
however, if i do this.. the column heading should be dynamic and show
the correct week number and correct month number it refers to ( not month 5 )..
how do u do t his..
is there any other way that we can set this up so that it shows weeks for current month and then monthly buckets for the rest of the 5 months?
Answer:
Yes, you can do this. What you need to do is:
1. Create a new selection in a KF structure.
2. Add in your KF and the Calender Week characteristic.
3. Add in the restriction for the Calender Week of "Current Calender Week" variable.
4. Click on the text button next to the description for this selection. You will have the option to select a text variable that is dynamically filled. Choose one.
5. Save, and copy that selection.
6. Paste the selection to duplicate it.
7. Edit the copied selection.
8. For the Calender week variable, select the offset and make it -1.
9. Repeat steps 5-8 for each calender week you want, each time incrementing the offset (-1, -2, etc...)
Then you can do the same thing for the previous 5 months, just select the calender month variable instead of calender week, and then do the variable offset on the "current month" variable.
This will dynamically (sort of) display what you want.
That should give you enough to get rolling w/ it.
- Stephen