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
- 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