When I try to use a list as a page selector in a dashboard, I get all the parent lists that are above the selected list in terms of hierarchy. For example, let's say if my geographical hierarchy which consists of 4 lists: Business Unit, Continent, Region and Country. Region is the parent for the Country, Continent is the parent for Region and so on.
The issue is when I try to publish the Country list as a page selector into a dashboard, the dropdown of this button shows me a tree structure of all the four levels instead of plainly displaying all countries together.
Is there a way to show only the level of hierarchy that is chosen?
Solved! Go to Solution.
This doesn't seem to be possible...
Within a module, you can pivot and hide/'select levels' to ensure that only the Country list items are displayed. However when publishing as page selector to the dashboard, these selections are ignored.
Same goes for Version selections as well (e.g hiding all 'Forecast' within the module then publishing page selectors...)
One alternative approach would be to use modules as selectors (+ Levels Filters) at the top of your dashboard. This way you allow the user to see / search all the countries across ALL Business Units OR allow them to select just those from a certain Business Unit (without displaying ALL the intermediary hierarchies).
Module 1: Use 'Select Levels' to display a single higher-level list item (e.g Business Unit or Continent). Reduce the column size of the line item displayed to 9 if you just want to display the list item.
Module 2: Ensure synchronization is on. Don't select levels / hide but use a Level Filter (link above) to enable synchronisation whilst showing only country list items
Hope this helps!
I tried something, Please follow the below steps:
1) Just a create a module. (Leave the Pages & Columns Section blank). In the line items enter the name that you want.
2) That line item you make, keep it list-formatted. (The list for which you want see the dropdown)
3) Now, Publish that Line item on the dashboard,then it should work.
As per my understanding, i would suggest you to try this...!
Hope this helps..!
Managing navigation on multi-level hierarchies can be challenging, but I like to advocate a separate dashboard to facilitate this
You set up selection modules for each level in modules and publish them as shown
You set syncronisation on and then as you navigate left to right (with selections), the grids adjust to ease the lower level selections
This declutters the dashboard (and can also be used for multiple dashboards) as well as providing a more intuiitive experience. It works especially well for numbered lists where the display name is the same
For the specific problem posted, you could use this approach to have a single module for " L4" and filter out all parents, but depending on the size of the list, it might again be worth having that module on a "selection" dashboard
Also don't forget the search option within Page selectors too. This can be an effective way to search for lower levels too
I hope this helps
I would like to go with @DavidSmith approach. But however still you need to put a boolean filter so that you will not be able to see the top level items.
Step 1 : Create a module with "Country" as dimension
Step 2 : Create a boolean line item and make it as true.
Step 3: Put a filter on this line item to be true and now you will be able to see only "Country" list items.
Step 4: Then hide the line item and publish the view to the dashboard to use for selection.
Hope this would be helpful!!
Thanks and Regards,