I might have a really simple question, but I can't quite figure it out.
Is there a way to show the available item variables in a page selector on a board? If I go into the page selector options by clicking on the edit button on a board I can see all available item variables for a specific dimension (for example under ‘available items’ or ‘default items’). But via de dropdown on the page selectors themselves it is not possible to use the variable as a filter?
The specific underlying use case is that I have created a subset of profit centers and I would like the end users to be able to view that specific subset of profit centers by filtering the page selector. They shouldn't manually have to click one-by-one.
I hope my question is clear Thanks a lot everybody!
Bas
Page 1 / 1
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.
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
Thanks a lot everybody!
