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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive