BeastMode Lead Function Doesn't Exist - Rolling Average

Hey guys, so I'm trying to apply this concept to my dataset, but when I tried to apply it I received the error, " Invalid Formula : This calculation is using a nonexistent function."
Apparently, the lead function doesn't exist in the BeastMode library but it did when this video was created.
(6) Domo - Analyzer - 3 month average lag - understanding Window Functions - YouTube
Did I do something wrong or is this a bug?
My data is not hardcoded.. I think.
lead(sum(`video_plays`)) over(order by YEAR(`date`) * 100 + WEEKOFYEAR(`date`))
Best Answer
-
Discovered the issue from the mighty Onyx themselves.
If you would like to use apply Windowed Functions, you will need to contact your CSM to enable Window Functions for BeastMode as it is a feature switch.
0
Answers
-
Discovered the issue from the mighty Onyx themselves.
If you would like to use apply Windowed Functions, you will need to contact your CSM to enable Window Functions for BeastMode as it is a feature switch.
0 -
Oh that's you! Hi. It's me.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 6 Cloud Amplifier
- 9 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
- 779 Automate
- 191 Apps
- 482 APIs & Domo Developer
- 83 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
- 145 Manage
- 141 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