Nest CASE Function in Beast Mode?
Hi,
I am new to Domo and am trying to set up a "nested" case function in Beast Mode (similar to a nested IF statement in Excel and am running into some issues. Can anyone tell me what is wrong with the below example? Many thanks!
CASE when `Car`= Red then '1' else
CASE when `Car`= Green then '2' else
CASE when `Car`= Blue then '3' else ‘4’ End
Comments
-
Because you are referencing strings you have to add delimiters.
So place the colors as such:
'RED'
'BLUE'
'GREEN'
0 -
You have a few syntax errors in the example below. The biggest issue is that you don't need to repeat the "case" portion of the case statement. It should look like this:
CASE
WHEN `Car` = 'Red' THEN 1
WHEN `Car` = 'Green' THEN 2
WHEN `Car` = 'Blue' THEN 3
ELSE 4
ENDI made a few other changes. You needed to have quotes around the colors (red, green and blue). If those were not there Domo would expect to see columns from the data grid with those names. I assumed that you were actually checking for the values red, green and blue in the data set.
I also changed the case statement to return numbers instead of characters.
-----
I work for Domo.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution"2 -
I'm trying to simuluate a nested IF(AND()) as used in excel. is that possible with BeastMode?
IF(AND(var 1= 'A', var2 + var3 > 0),'YES', IF(AND(var1 = 'A', var4 = 'No'),'No','')))
is this possible?
0 -
you would use a case statement and it would look something like this
CASE when `var 1`= 'A' and `var2` + `var3` > 0 THEN 'YES' When `var1` = 'A' and `var4` = 'No' then 'No' else '' end
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1 -
Why does the following not work?
@cwagnerwrote:Hi,
I am new to Domo and am trying to set up a "nested" case function in Beast Mode (similar to a nested IF statement in Excel and am running into some issues. Can anyone tell me what is wrong with the below example? Many thanks!
CASE when `Car`= Red then '1' else
CASE when `Car`= Green then '2' else
CASE when `Car`= Blue then '3' else ‘4’ Endcase
when (MONTH(`Created Date`)= '1' then 'Jan'
when (MONTH(`Created Date`)= '2' then 'Feb'
when (MONTH(`Created Date`)= '3' then 'Mar'
when (MONTH(`Created Date`)= '4' then 'Apr'
when (MONTH(`Created Date`)= '5' then 'May'
when (MONTH(`Created Date`)= '6' then 'Jun'
when (MONTH(`Created Date`)= '7' then 'Jul'
when (MONTH(`Created Date`)= '8' then 'Aug'
when (MONTH(`Created Date`)= '9' then 'Sep'
when (MONTH(`Created Date`)= '10' then 'Oct'
when (MONTH(`Created Date`)= '11' then 'Nov'
when (MONTH(`Created Date`)= '12' then 'Dec'
end0 -
You don't need to leading parenthesis (and it wasn't being closed). The following should work now.
case
when MONTH(`Created Date`)= '1' then 'Jan'
when MONTH(`Created Date`)= '2' then 'Feb'
when MONTH(`Created Date`)= '3' then 'Mar'
when MONTH(`Created Date`)= '4' then 'Apr'
when MONTH(`Created Date`)= '5' then 'May'
when MONTH(`Created Date`)= '6' then 'Jun'
when MONTH(`Created Date`)= '7' then 'Jul'
when MONTH(`Created Date`)= '8' then 'Aug'
when MONTH(`Created Date`)= '9' then 'Sep'
when MONTH(`Created Date`)= '10' then 'Oct'
when MONTH(`Created Date`)= '11' then 'Nov'
when MONTH(`Created Date`)= '12' then 'Dec'
endSincerely,
ValiantSpur
0
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 968 Connectors
- 256 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 500 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 367 Beast Mode
- 19 Variables
- 483 Automate
- 101 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive