Can I Create Variables in Beast Mode?
I'm trying to create a variable that I can reference a beast mode calculation, but it keeps on telling me "This calculation contained a syntax error".
Is it not possible to create variables in Beast Mode? Or am I just messing up the syntax?
I've tried:
set @month=1
set @month:=1
select @month=1
select @month:=1
But none of them work.
This is the first line of my beast mode calculation, and it's followed by a CASE statement.
Thanks in advance!
Best Answer
-
You can't create variables in beast mode.
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'2
Answers
-
You can't create variables in beast mode.
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'2 -
Shucks.
Well, good to know, thanks.
2 -
You can create a first Beastmode with a case statement but if you want to call it in other calculation, you will have to use the actual formula first created, otherwise it will give you a syntax error.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'4 -
Let's move to PowerBI where DAX easily allows you to create variables and use custom formulas inside custom formulas.. food for thought
2 -
It is very unfortunate that we cannot introduce variables in Beast Mode and it has made my calculated fields look really convoluted and difficult to follow. I hope that we can see some improvements.
0 -
@Musetti I think this is currently in beta - they presented on the functionality at the user group community event. You can see the recording in this post: https://dojo.domo.com/main/discussion/55230/june-2022-user-group-recordings#latest
3
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 86 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive