Can Magic ETL calculate a sum over an entire column?
I hope I am missing something here.
I want to simply run the equivalent of SELECT SUM(columnA) from TableB in Magic ETL. However, it seems the only way to do this sum is: 1) add a columnC to TableB where every row in columnC is the same value, and 2) do a Group By aggregating on columnC.
Is there a better way in Magic ETL?
Best Answer
-
Magic ETL does need a column to be selected. The easiest way to do this is to use the Add Constant tile and create a column with a constant value or do the same with the add formula tile. Then, just add this column to your group by and sum on the field you need to sum up. You can remove afterwards with the select columns tile.
**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.1
Answers
-
Magic ETL does need a column to be selected. The easiest way to do this is to use the Add Constant tile and create a column with a constant value or do the same with the add formula tile. Then, just add this column to your group by and sum on the field you need to sum up. You can remove afterwards with the select columns tile.
**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.1 -
Thanks for confirming, @MarkSnodgrass
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 803 Beast Mode
- 79 App Studio
- 44 Variables
- 758 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 73 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive