Combining Filtered Rows to one table

SamanthaC · 2025-03-14T05:12:26+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Cards

Filters

Table

Formatting

Beast Mode

Accepted answers

All comments

Manasi_Panov

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.

DavidChurchman

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.

SamanthaC

Hi David and Manasi. Thank you both! I was able to consolidate these as needed! Now I am trying to add in further formulas/calculations onto this data so have opened a new question regarding beast modes mimicking simple excel calculations. I've linked it here if you could help further! Thanks!

https://community-forums.domo.com/main/discussion/69335/replicating-multiple-excel-calculations-as-rows-of-data-beast-mode