Filtering data with 2 columns with beast mode?
Now I have a dataset something as below;
ID | Cat | Name | Cond01 |
---|---|---|---|
0001 | 1 | A | 3 |
0002 | 2 | B | 4 |
0002 | 1 | A | 3 |
0001 | 1 | D | 1 |
0003 | 2 | B | 7 |
0003 | 1 | C | 5 |
0004 | 1 | A | 9 |
… | … | … | … |
Now I want to make two filter cards to select data by Name
, conditioned with a Cat
value,
where one card is for filtering data by Name
when Cat
= 1,
another one by Name
when Cat
= 2.
I want to extract data, for example, Name
=A When Cat
= 1 with the former and Name
=B When Cat
= 2 with the latter to get as below;
ID | Cat | Name | Cond01 |
---|---|---|---|
0001 | 1 | A | 3 |
0002 | 2 | B | 4 |
0003 | 2 | B | 7 |
0004 | 1 | A | 9 |
But they don't work, they work separately.
Does anyone have an good idea to filter data with filter cards as above?
Thanks in advance!
Best Answer
-
Because you want to see the two combinations simultaneously, you'll need to combine the two columns. I did this using CONCAT(). I don't think this is the perfect solution, but it works. If you have many combinations of Cat and Name then this may not be ideal.
- Create a beastmode: CONCAT('Cat = ',
Cat
,' & Name = ',Name
) - Make the above beastmode a filter on the table card
- Make the selections in the filter:
4. End result is what you're looking for:
If I solved your problem, please select "yes" above
0 - Create a beastmode: CONCAT('Cat = ',
Answers
-
Because you want to see the two combinations simultaneously, you'll need to combine the two columns. I did this using CONCAT(). I don't think this is the perfect solution, but it works. If you have many combinations of Cat and Name then this may not be ideal.
- Create a beastmode: CONCAT('Cat = ',
Cat
,' & Name = ',Name
) - Make the above beastmode a filter on the table card
- Make the selections in the filter:
4. End result is what you're looking for:
If I solved your problem, please select "yes" above
0 - Create a beastmode: CONCAT('Cat = ',
-
Thanks, ColemenWilson. It worked for tables to me.
But indeed, what I really want is to make two or more filter cards function separately to get the data.
For example, filter card X contains
Name
values A and C, and Filter card Y contains B and D.But choosing B of filter card Y after choosing A of filter card X, the choice of A is cancelled.
0
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
- 49 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
- 115 Manage
- 112 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