Global Formulas in ETLs

jimsteph
Contributor

I would like to have a way to create complex formulas, save them (similar to the Beast Mode Manager) , and then have them available for use in ETLs; when an ETL that contains one of these formulas is executed the current version of the formula would always be used. This would have two use cases (for me):
- If there is a need to change the formula -- a change in business needs, error fixes, etc. -- it would only need to be changed in one place. Once changed, the updated formula would automatically be used in all ETLs that contain it. This would keep the formula from getting out of sync in the various ETLs that use it when we unknowingly skip one when trying to update them all.
- If there are multiple paths in an ETL -- for example, I'm trying to calculate member status for each of the past seven days, and this ends up having to be done in seven parallel paths -- changing the formula at the global level would change it in all paths.
Thanks!
Jim
4
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 86 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive