Is there any way to add a large number of items to a Card Filter all at once?
I regularly need to filter a large dataset (7000+ rows) by selecting 50-100 of the specific items in the column I've selected. Unfortunately, it is cumbersome and time consuming to find them one by one from the full list, or to copy/paste each of them individually into the filter search box.
Is there any way to dump a large list of items into the search box in a comma-separated or other fashion to accomplish filtering down to them all at once? The goal would be to copy/paste from an Excel List or CSV file.
Thanks!
Best Answer
-
A couple ways that we have used to work around this issue:
1) If its always the same items for the analysis, create a BeastMode Filter using a 'Case When' statement and list out of the items one time in a Case Statement (actually used excel to program the statement and copied it into Domo so I didn't have to type all the items). When the item number is in your list lable it "True", if not "False". Use this Calculation in your filter to show only "True".
2) Similar to #1, but involves using a Webform inside a dataflow. Create a Webform table in Domo and insert it into your Dataflow. Then you will have the same type of "True" or "False" column to use as a filter.
They are basically the same concept, the difference is that one is managed through a BeastMode and the other is managed through the Webform.
5
Answers
-
Is anyone able to help out with this request?
0 -
A couple ways that we have used to work around this issue:
1) If its always the same items for the analysis, create a BeastMode Filter using a 'Case When' statement and list out of the items one time in a Case Statement (actually used excel to program the statement and copied it into Domo so I didn't have to type all the items). When the item number is in your list lable it "True", if not "False". Use this Calculation in your filter to show only "True".
2) Similar to #1, but involves using a Webform inside a dataflow. Create a Webform table in Domo and insert it into your Dataflow. Then you will have the same type of "True" or "False" column to use as a filter.
They are basically the same concept, the difference is that one is managed through a BeastMode and the other is managed through the Webform.
5 -
That's a terrific idea. Thank you!
1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 562 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive