Dynamic filtering with large lists
Is it possible to pate a list of values from a text file or an excel column to filter down a table view or a dashboard? I want to be able to constantly filter for different large lists of ids to only show data for these ids in the dashboard or cards.
Comments
-
Hi @user038587
The easier option is to take that excel file upload it to Domo and utilize a dataflow with a join to filter on those values. One caveat to this though is that it will remove the other values and you won't be able to filter on those values any more in your card.
There isn't a way to filter on a giant list via the card filters currently.
There is a Beta currently for filter page views which would allow you to pre-define (although this would be manual and could take some time) and save those filters. Then a user can just select the pre-defined filter on the page and filter your dataset that way.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Instead of uploading an excel spreadsheet, i'd use a Webform because then I can alter the values as necessary inside the Domo UI.
Instead of JOINING in ETL, I'd use a Fusion to LEFT JOIN the data. By using a Fusion you don't have to wait to reprocess the data if you want to add a new filter criteria. It'll be instantaneous.
You can extend this into Scenario Modeling.
Imagine you have two columns
Account_ID, Scenario
and you create 6 account_IDs for Scenario 1
then you can also add 10 account_IDs for Scenario 2.
Super easy in your analyzer because now you cal filter on the Scenario column to show the data by different Scenarios.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 11 App Studio
- 27 Variables
- 578 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 351 Distribute
- 91 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive