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
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 106 SQL DataFlows
- 646 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 774 Beast Mode
- 75 App Studio
- 43 Variables
- 730 Automate
- 186 Apps
- 469 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 403 Distribute
- 117 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 136 Manage
- 133 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive