ConsolidationDay to 'Wed, Fri' for 'Spektra' and fill null values for this?

I am trying to create a beast mode where when the customer = 'Spektra' then the ConsolidationDay = 'Wednesday, Friday'. I also need this to populate the ConsolidationDay cells with 'Wednesday, Friday' as they are currently null.
What would be the correct Beastmode to do this?
Best Answers
-
It's a little unclear what you want ConsolidationDay to be when the customer is not 'Spektra', but otherwise, this should work:
CASE
WHEN
customer
='Spektra' THEN 'Wednesday, Friday'ELSE 'What you want ConsolidationDay to be when the customer is not Spektra'
END
If you want it to be null when the customer is not 'Spektra', then just delete that ELSE line.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0 -
Tweaking that a bit…
CASE
WHEN `Customer` = 'Spektra' AND `ConsolidationDay` IS NULL THEN 'Wednesday, Friday'
ELSE `ConsolidationDay`
END** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Answers
-
It's a little unclear what you want ConsolidationDay to be when the customer is not 'Spektra', but otherwise, this should work:
CASE
WHEN
customer
='Spektra' THEN 'Wednesday, Friday'ELSE 'What you want ConsolidationDay to be when the customer is not Spektra'
END
If you want it to be null when the customer is not 'Spektra', then just delete that ELSE line.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0 -
Tweaking that a bit…
CASE
WHEN `Customer` = 'Spektra' AND `ConsolidationDay` IS NULL THEN 'Wednesday, Friday'
ELSE `ConsolidationDay`
END** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 664 Datasets
- 120 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
- 90 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