OFFSET function in a table view
Hey Dojo!
I'm looking to create a table that will dynamically show change between the row and the row above it. We need the table to automatically update the formula when one of the rows is filtered out (which makes doing this in ETL impossible). My idea was to do this with an LAG function or an OFFSET function, but since we're working in beast mode I don't belive LAG is an option. I appreciate any advice you all have and have provided a quick example of how I would like the table to behave!
Thanks!
Best Answer
-
Window functions are available in beast mode, but they are not turned on by default. Ask your CSM to enable "window functions in beast mode". They will get enabled and then you should be do it. You won't have any intellisense when you type, but the functions will validate.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2
Answers
-
Window functions are available in beast mode, but they are not turned on by default. Ask your CSM to enable "window functions in beast mode". They will get enabled and then you should be do it. You won't have any intellisense when you type, but the functions will validate.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 666 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 827 Beast Mode
- Visualize
- 2.6K Charting
- 90 App Studio
- 46 Variables
- Automate
- 198 Apps
- 489 APIs & Domo Developer
- 98 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 118 Domo Everywhere
- 284 Scheduled Reports
- 11 Software Integrations
- Manage
- 145 Governance & Security
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 117 Community Announcements
- 5K Archive