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.
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
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
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 77 Cards, Dashboards, Stories
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive