We have Year as a page selector on the DB created from a module (Time(Year) X Users) with blank boolean line item. But whenever we are opening the Dashboard for first time it always shows only 3 months of data. If we re-select the year from page selector, it starts showing 12 months.
Can someone please help what can be done to fix it?
Ok can you try creating a Year filter for the month module. The filter should work off of a checkbox in a module with dimension of Year. So user will select a year and that applies a filter to the month module and will show only the months belonging to that year This should solve the issue
Yes, this module is exactly the way it should be set up.
Have you also created another line item in your month module which refers this line item? The formula for this should be Year Module.Select[LOOKUP: Month.Year]. And then you should apply this line item as a filter