Hi All,
Could you please help me solution for this use case:
Use case: I have a list of Communities with Multiple List formatted properties having User List as dimension. These are to map Community managers, Regional Managers and so on. Now on a board I have this grid with Communities on rows. I want to add a regional director and community manager filter on pages in such a manner that when I select a Regional Manager, I can only see the community managers that roll up to it and when I select a community manager then I only see the communities for that community manager.
Issue: Once I add a property from Community list which is User List formatted, I can’t add another property with the same dimension
Solutions I have already tried: I created a separate Regional Director List with all users with that role within the application. Then I created a metric to Identify all community managers that roll up to that regional manager against the respective communities they have access to. End result of all my calculations: I now have a metric identifying which community managers roll up to which regional manager and consequently which community rolls up to this community manager. I tried using this in my grid using “Map a dimension to the view” feature but nothing seems to be working as expected.
Multiple User Filters on Rows
- Master Author
- Employee
Hi there! Thanks for the detailed write-up!
What you want is a cascading filter (Regional Manager selection limits the Community Manager choices, then Community Manager limits the Communities shown). In Pigment, filtering the results is usually doable, but dynamically restricting the available values in a second user-based filter can be limited when multiple list properties use the same underlying User dimension in the same view.
The most reliable approach is to drive this through Variables + a mapping metric (Regional Manager → Community Manager → Community), and use that mapping to filter what the widget displays.
Help Center: https://kb.pigment.com/docs/filter-data-pigment
- Master Author
1) I created properties within that list to identify 1st Occurrence of Community Managers, Regional Managers and so on.
2)Imported these to separate list using list to list import. Created a new text-based property to store User’s name which then I set as default property of this list
3)Then I created properties within the community list with these individual lists I created. Since these lists are not User List anymore because I am essentially using the text field in these lists, this allows me to add all these lists as filters to the board.
4)Lastly, I added all import actions in a process
This may sound like a lot of work, but this is the only approach that was clean to implement and works well for me.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.