Dynamic filter on a hierarchy
Hi,
I built a dynamic filter on a dashboard so users can select multiple criteria. On the department filter, the end-user can only select the bottom level of the hierarchy and not a parent. This is because the filter is dimensioned by the lowest level of the department hierarchy. What's the solution to get around this limitation where I can keep the filter as a dynamic dropdown.
Best Answer
-
@michael.chefer Unfortunately, I dont think what are you are looking for is an option. There might be a couple of different ways to do something similar.
- Use a series of Dependent drop-downs that allow you to select a higher level of the hierarchy. You wouldn't have to select all levels, but could make the filter apply to anything underneath the selection.
2. You could use boolean filters to have the end user checkboxes vs using the drop-down. Here I have a module dimensionalized by My Lowest level (L3) but have subsidiary views on 2 other lines for the L1 and L2 of my hierarchy. I use a final line where I bring it all together:
Not sure if either of these will work for your situation, but it is the best I can think of as a work around.
Jason
0
Answers
-
Thank you! You basically saved my life :) @jasonblinn
Do you have an insight into solving this issue?
0 -
@jasonblinn as a post script to this post, I used a combination of your 2 options above where end-users make a selection from a dropdown(s) which drives booelans in a "Final Filter."
0