Allow Window Functions in MagicETL Formula Tile
MichelleH
Coach
It would be helpful to be able to write MagicETL formulas using window functions, similar to in beast mode. While the Rank & Window tile is often sufficient, there are some use cases where having this feature in the Formula tile would simplify the dataflow steps:
- Using a sum window function with unbounded rows
- This does not work consistently in the Rank & Window tile
- Creating multiple window functions with different partitions
- Users currently have to create a separate tile for each partition criteria, whereas it would be nice to contain these functions within a single tile
- Adding a case statement within the aggregation
- In current state this requires adding a calculated field in a forumla tile, then using it in a subsequent Rank & Window tile. It would be simpler to do it all at once in the original formula tile
Tagged:
10
Comments
-
This is a great callout, and one that we are in the process of resolving. We are working on including Window Functions in v2 of the SQL Tile (v1 is in a very limited beta now). I anticipate we will have Window Functions available in the SQL Tile around the end of the year.
Domo Product Manager for Data Transformation (MagicETL)
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 564 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive