Windowed functions in Magic ETL 2.0
Does anyone know how to apply a dynamic range for windowed functions using SUM in Magic ETL 2.0? I would like to use another column value with the beginning range date in the range, but Magic ETL only allows static values.
0
Answers
-
You can create additional columns based on date calculations to get the range you want and then filter to that range and then use the rank and window tile to do your window functions.
If you provide more details as to what you are doing, I might be able to provide a more specific solution.
**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.0
Categories
- 7.4K All Categories
- 13 Getting Started in the Community
- 151 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 905 Connectors
- 239 Workbench
- 343 APIs
- 77 Apps
- 19 Governance & Productivity
- 237 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部