BETWEEN Beastmode function not working
Hi All,
I often build beastmodes and find that the in-built function "Between" never seems to function.
If you type "Between" into the function search, nothing comes up, but if you start typing "Between", it's an option like AND, OR, etc. would be.
I presume the intended function would typically be utilised in truncating values in case statements without needing a greater than and a less than part.
e.g.
CASE
WHENvalue column
BETWEEN X AND Y THEN 'Is Between' ELSE 'Is Not Between' END
However, whenever I try to utilise Between in this way, the beastmode can never validate. Is a specific expected notation needed to use Between, or is it simply not working as intended?
Best Answer
-
I think the "BETWEEN" function is meant for the formula tile in MagicETL. That's why it probably shows up as a auto completion in the analyzer.
I agree that Domo should clean up the auto completion and show only functions that work in Analyzer beast modes.
1
Answers
-
I can't find anything in Domo's documentation that suggests BETWEEN is supported. I've always used:
value column >= X and value column < = Y THEN 'Is Between'If I solved your problem, please select "yes" above
1 -
Aye, this is exactly my comment - "Between" is an auto-completed option in the beastmode window, but it's seemingly either unsupported, undocumented or broken.
The most logical use case, as described above doesn't work, there is no documentation as you have alluded to, but its existence as an auto-completing suggests there should be some functionality. I also do the same thing as you have described; it just seems like a bloated bit of code.
0 -
So is the alternative to get the same result that I suggested not working? Or you're only trying to use BETWEEN?
If I solved your problem, please select "yes" above
0 -
I'm highlighting that there is seemingly a problem with the functionality of "Between"
I consistently use the process you have already highlighted as it's a workaround to what the expected use case of "Between" is.
The question was not asking "How do I solve this" as it's a layman's problem, the question was "If this is not the use of Between; what is it there for?".
0 -
If you haven't already, I would suggest submitting a request to Domo Support.
If I solved your problem, please select "yes" above
0 -
I think the "BETWEEN" function is meant for the formula tile in MagicETL. That's why it probably shows up as a auto completion in the analyzer.
I agree that Domo should clean up the auto completion and show only functions that work in Analyzer beast modes.
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive