May I have your support with a query I had raised and to which I have not had a response yet.
This is my original query.
When pivoting time, I lose the weekly views and can only see the month's numbers, may I confirm how I can retain the weekly views whilst moving the months into the pages section.
I was advised to do the below:
All you need is a line item dimensioned by time (time formatted - month), a line item dimensioned by time (boolean) and a line item which you will use as a user filter (month). User will select month via this filter. And it will drive the boolean to match the month.
Month Li formula will have ITEM(TIME).
Boolean formula: Month Li = Filter
Then apply module with a filter by Filter Li
My first question is whether this has to be done in the SYS01 time module? What boolean formula am I to apply exactly, I'm not sure how to do this, is it a separate line item?
Not exactly, because unfortunately you can't publish page selector without the grid. But you can put this dummy grid in the end of your page (the months dimension has to be as page selectors in it's view). Then you have to enable Time filter on the Context tab for the main grid and enable syncronize. This has to work.