Bucket Only Two Fields and All Data Remains the Same
I am attempting to bucketize only two data fields while leaving the other data with the same names. In this case, I'd like both lead sources that contain "Saleforce" to be in one bucket called Salesforce, I'd like the remaining lead sources to keep their respective names. When I use the formula at the bottom, it only buckets the Salesforce items and the remaining lead sources stay in an unnamed bucket. Please finish the formula at the bottom to prompt Beastmode to keep the remaining fields as they are.
Example:
Lead Source - Salesforce
Lead Source - Salesforce.com
Lead Source - Microsoft
Lead Source - Oracle
Formula:
CASE
WHEN `Lead Source Detail` like '%Salesforce%' then 'Salesforce'
End
Best Answer
-
You almost had it. See small addition of ELSE statement below:
CASE
WHEN `Lead Source Detail` like '%Salesforce%' then 'Salesforce'
ELSE `Lead Source Detail`
EndHope that helps,
Valiant
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1
Answers
-
You almost had it. See small addition of ELSE statement below:
CASE
WHEN `Lead Source Detail` like '%Salesforce%' then 'Salesforce'
ELSE `Lead Source Detail`
EndHope that helps,
Valiant
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive