Allow for Min & Max in the Rank & Window Tile in Magic ETL

GrantSmith
Coach

The minimum and maximum aggregation are standard calculations that should be included in the rank and window tile but currently are not. They should be added to avoid having to use a group by and then joining back to the dataset for simplicity and efficiency.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
**Did this solve your problem? Accept it as a solution!**
5
Comments
-
I second this!
0 -
If we're talking about wishes, I'd also love LIST_AGG to be included, but I know that is not as standard 😅
0 -
Most of the time, I'd rather just run a slew of over/window functions in a formula tile rather than using the R&W tile at all. Then I can set individual partition and order parameters for each column. As far as I can tell, function tiles don't let you do that.
0
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 966 Connectors
- 254 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 75 SQL DataFlows
- 499 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 360 Beast Mode
- 19 Variables
- 482 Automate
- 101 Apps
- 377 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive