Month and Actual Goal
Hello all looking to make a case statement, I could be using the wrong one. I want to have a Beast mode that states when a specific month then it states what the goal is, picture below.
Thank you in advance
Best Answers
-
Why are you including the THEN '12' or THEN '9' clauses? This isn't valid syntax. You can only have one then clause for each where clause.
If you're wanting to combine both values together you can use CONCAT:
CASE WHEN MONTH(`Date`) IN (10,1,2) THEN CONCAT(`Actual Goal`, ' 12') WHEN MONTH(`Date`) IN (11,12) THEN CONCAT(`Actual Goal`, ' 9') END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
CASE WHEN MONTH(`Date`) IN (10,1,2) AND `Actual Goal` < 12 THEN 'Yes' WHEN MONTH(`Date`) IN (11,12) THEN AND `Actual Goal` < 9 THEN 'Yes' ELSE 'No' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Why are you including the THEN '12' or THEN '9' clauses? This isn't valid syntax. You can only have one then clause for each where clause.
If you're wanting to combine both values together you can use CONCAT:
CASE WHEN MONTH(`Date`) IN (10,1,2) THEN CONCAT(`Actual Goal`, ' 12') WHEN MONTH(`Date`) IN (11,12) THEN CONCAT(`Actual Goal`, ' 9') END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@A_Benincasa The formula should work if you remove
THEN `Actual Goal`
from each line. In case statements WHEN identifies which rows to consider and THEN specifies what value to assign to those rows, so the formula will not work if there are multiple THENs for each WHEN.1 -
@GrantSmith Thank you! I need to now add in a section that states, " Was Goal met Y/N" if it is less than those numbers above how would I include that in the beast mode?
0 -
CASE WHEN MONTH(`Date`) IN (10,1,2) AND `Actual Goal` < 12 THEN 'Yes' WHEN MONTH(`Date`) IN (11,12) THEN AND `Actual Goal` < 9 THEN 'Yes' ELSE 'No' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
The < sign does not work in a beast mode
0 -
It should work, what type of error are you experiencing with the beast mode?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@GrantSmith it's stating there is a syntax error, I am thinking it's because it referencing month numbers and not the name, but when I swap it out I get the same error
0 -
Can you paste in your beast mode?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive