Combining Filtered Rows to one table

Hello,
I am using one dataset for all three cards shown below. I have them on separate cards right now as they each are filtered to different things.
Is there a way I can combine them so they would all show on one card/table together with one heading but show the three rows one under another with their filters still applied to each row? Could I create a formula/beastmode that lists out each filter criteria and make that a new column basically and then have the data columns follow as they do now? If so how would something like that be formatted or do you know of other ways to approach this?
Thanks!!
Sam
Answers
-
Hi @SamanthaC,
Yes, this can be accomplished using a CASE statement in Beast Mode. However, the results will be displayed in a column rather than rows. If you provide additional details or a sample dataset, Iād be happy to assist further.
If you found this post helpful, please use š”/š/š/š below! If it solved your problem, don't forget to accept the answer.
0 -
Agree with Manasi, you could use a CASE statement in a BeastMode. Something like:
CASE
WHEN [conditions for first table] THEN 'Row 1'
WHEN [conditions for second table] THEN 'Row 2'
WHEN [conditions for third table] THEN 'Row 3'
ELSE 'Exclude'
END
Then filter your card to exclude the 'Exclude' rows.
Please š”/š/š/š this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 307 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 790 Beast Mode
- 78 App Studio
- 43 Variables
- 746 Automate
- 187 Apps
- 475 APIs & Domo Developer
- 68 Workflows
- 16 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive