Is there any way to add a large number of items to a Card Filter all at once?

coreyvsmith · January 2018

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!

bdetcher · January 2018

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.

Chronos · January 2018

Is anyone able to help out with this request?

bdetcher · January 2018

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.

coreyvsmith · January 2018

That's a terrific idea. Thank you!

Is there any way to add a large number of items to a Card Filter all at once?

Best Answer

Answers

Categories