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.
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`))
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board