Variable Response in Beast Mode

In the Beast Mode below, End Date 2, Start Date 2, Measure Selection and Client Select are all variables. For the Measure Selection and Client Select, is there an alternative to hardcoding the literal value for each Client Select & Measure Selection permutation? Is there a way to take the variable response and feed it into the beast mode?
SUM(CASE
WHEN Date
<= End Date 2
AND Date
>= Start Date 2
AND Measure Selection
= 'Clicks' AND Client Select
= 'Acme' THEN CASE WHEN Benchmark Client Groups
LIKE '%Acme%' THEN Clicks
end
WHEN Date
<= End Date 2
AND Date
>= Start Date 2
AND Measure Selection
= 'Revenue' AND Client Select
= 'Acme' THENCASE WHEN Benchmark Client Groups
LIKE '%Acme%' THEN Revenue
end
WHEN Date
<= End Date 2
AND Date
>= Start Date 2
AND Measure Selection
= 'Clicks' AND Client Select
= 'Beta' THEN CASE WHEN Benchmark Client Groups
LIKE '%Beta%' THEN Clicks
end
WHEN Date
<= End Date 2
AND Date
>= Start Date 2
AND Measure Selection
= 'Revenue' AND Client Select
= 'Beta' THENCASE WHEN Benchmark Client Groups
LIKE '%Beta%' THEN Revenue
end
ELSE 0
END)
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 664 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 194 Apps
- 484 APIs & Domo Developer
- 89 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 119 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive