Error in Case statement in Beastmode
Hi there, I'm getting this error when creating a case statement in Beast mode. Hoping someone can help?
Invalid Formula : A column in this calculation did not exist.
This is the case statement. It's pretty simple, and the column definitely exists in the dataset, so I'm not sure why it won't work.
CASE
when `Active days` >= 90 then "90+ Days"
when `Active days` >= 60 then "60-90 Days"
when `Active days` >= 30 then "30-60 Days"
when `Active days` < 30 then "<30 Days"
end
0
Best Answer
-
The issue is that you are using double quotation marks in your then statement. It should be single quotes like this:
CASE when `Active days` >= 90 then '90+ Days' when `Active days` >= 60 then '60-90 Days' when `Active days` >= 30 then '30-60 Days' when `Active days` < 30 then '<30 Days' end
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
facepalm. thank you.
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有