Hidden Beast Mode Functions

Hello, I was wondering if anyone created a list of hidden beast mode functions like Partition By which is not shown in the function list, but it works when we actually use it.
Best Answer
-
The best resource is the Beast Mode KB article.
Another thing that I will sometimes do is to check the functions that work in ETL. Not all of them cross over to Beast Mode, but some do that are not listed in the Beast Mode function list in Analyzer. For example SUBSTRING_INDEX().
Lastly, beast modes are based on MySQL. There have been times when I've just tried something to see if it works, and it has.
In general, most of the functions that work are documented. The particular example you gave is actually a clause in a window function.
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**0
Answers
-
The best resource is the Beast Mode KB article.
Another thing that I will sometimes do is to check the functions that work in ETL. Not all of them cross over to Beast Mode, but some do that are not listed in the Beast Mode function list in Analyzer. For example SUBSTRING_INDEX().
Lastly, beast modes are based on MySQL. There have been times when I've just tried something to see if it works, and it has.
In general, most of the functions that work are documented. The particular example you gave is actually a clause in a window function.
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 6 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 780 Automate
- 191 Apps
- 482 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 413 Distribute
- 121 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive