Filter on item variables in page selector

Hi Bas,

In your case I would create a member based variable using a Boolean metric dimensioned by User and Profit centers.

Then apply this variable in the “Default items” as a Page options, keeping the the selection as multi. 

Example:

If I open my page options and see the default items list, I see everything, variables + all items.

Now, if I set my Last 12 Months variable as default, apply the page options, my view is now pre-filtered with my default items.

If you use the “Available items”, you would still have to select all the items in the dropdown but would only see the relevant ones.

With “Default items” they’re all selected dynamically by default.

More information on variables and page options

https://community.pigment.com/reporting%2Ddata%2Dvisualization%2D83/what%2Dare%2Ditem%2Dvariables%2D610 

Hope this helps!

Best,

Hi Benoit! 

Thanks for your reply. I understand that creating a member-based variable can help in filtering the default items. But it is not possible on the board itself to filter by a subset of items?

For example like below? So that the end user can select “A” or “B” and then only see the profit centers that are grouped under that subset.

→ If the groups are the same for all users and Profit Centers can only have one Group
I would probably approach this with a parent dimension mapping.

In the Profit Center dimension, I create a new dimension property like “Profit Center Group” and assign a Group to each Profit Center.

So you can then filter using this parent group dimension:

• item 1 = Group A
• item 2 = Group B

And with adaptive display with dynamic selection, if you select group A, the dimension Profit Center would auto filter on the items included in GroupA.

You can even have a member-based variable per User per group.

→ If the groups are different per user
I would use different member-based dynamic variables, one per group.
So that in the Profit Center page selector you’d have 
☐ Group A variable
☐ Group B variable

Please let me know if you have further questions.