How to cascade filter single dropdowns in Domo App design Studio?
Hi,
I'm creating "dashboard" in Domo App Design Studio (Adobe Illustrator extension) and need to cascade filter two single dropdowns values...
I.e. when "Region 1" selected in Dropdown 1 then only relevant subregions for region 1 should be displayed in Dropdown 2 and so on...
How can i do this?
Thanks
Karel
Comments
-
Hi Karel,
What you will have to do is set up two filters in the app. You will have to add your secondary filter to the "WIDGETS TO FILTER" section of the primary filter and choose "Display Name" as the Column to Filter. So when you make a selection on your primary filter it will cascade to your secondary filter.
An example of how this works ...
Your primary filter might have this data ...
Display Name Value
North North
East East
South South
West West
And your secondary filter would have this ...
Display Name Value
North Bob D
North Rachel G
West Susan S
West Mike S
South Steve P
South Carol S
East Sid K
East Jordan S
In this scenario, when you filter North in your primary filter, only Bob D and Rachel G will show as selections in your secondary filter.
Good luck,
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
HI Brian,
thanks for your reply.
Single dropdowns does not have any "WIDGETS TO FILTER" option so I'm not able to select.
On the other side - multiple select dropdowns have such option, and I'm able to filter. But the issue in this scenatio is that only THE LAST item from filtered list is displayed in the second dropdown.
For instance if I use below mentioned lists it will show this:
Dropdown1 selected EAST
Dropdown2 shows one item labelled "Jordan S" while expected is to show two items labelled "Sid K" and "Jordan S"
Thanks for any further advice
Karel
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive