Best Of

I believe what @pauljames is saying is that in beast mode each row only evaluates to one value. You can't return "Facebook" and "All" for the same row. Using the formula provided, if the user selects nothing, that effectively means "All".

"that massive CASE statement should probably really be a join to a lookup table. "

I hope to you see at Domo Connections - Dallas.

In my situation, I use a CASE statement to standardize insurance company names. Since users can enter these names in thousands of different ways, my CASE logic reclassifies them. With just a single ILIKE condition, I can often capture a wide range of variations. It’s surprising how many different entries exist just for BCBS (Blue Cross Blue Shield) and its related companies.

BCBS is only one entity. Now multiply that need by hundreds of entities.

The days of trying to construct a long and complicated formula in an itty bitty little formula editor are over - you asked and we heard you: we've now added the ability to collapse the Tools section of the expanded formula editor in Magic ETL. This went live in your Domo instance yesterday. Just open the expanded formula editor in one of the tiles where you write formulas (Add Formula, Join Data, Filter Rows, or Group By) and click the caret on the Tools bar to collapse all of that documentation and noise. Click the caret again to bring it back when you need it for reference.

My team and I love being able to slip in these little quality of life updates, amid our bigger feature efforts. We hope this makes the process of writing that formula more pleasant and improves your life just a little bit.

(…although I hate to tell you this, but that massive CASE statement should probably really be a join to a lookup table. #justsaying)

— Your Friendly Neighborhood Magic ETL Product Manager 🙌

The easiest thing would be to use a Slicer filter instead of a Radio filter, which gives options to select multiple or select all. But, a more literal answer to your original request is using a variable:

1. Create a variable (let's call it channel_variable, with the possible values of 'Facebook', 'Instagram', 'TikTok', 'Others', 'All'

1. Create a BeastMode (let's call it channel_filter) using that variable. I haven't tested this, but I think this would work:

CASE
WHEN channel_variable = 'Facebook' AND channel_id = 1 then 'Include'
WHEN channel_variable = 'Instagram' AND channel_id = 2 then 'Include'
WHEN channel_variable = 'TikTok' AND channel_id = 3 then 'Include'
WHEN channel_variable = 'Others' AND channel_id in (1,2,3) then 'Include'
WHEN channel_variable = 'All' AND channel_id in (1, 2, 3, 4, 5) then 'Include'
ELSE 'Exclude'
END

3. Create a filter on the car using the channel_filter BeastMode, filtering for 'Include'

4. Add the channel_variable as a control to your page.