Group By -- all additional columns
user027926
Member
in Magic ETL
I have a data set that looks something like this:
Rep Name --- Department --- Month 1 --- Month 2 --- Month 3 etc.
I want to do a 'group by' as some reps appear on multiple rows and I want to sum the Month total for those reps. That part is easy.
Is there a way to automate that all future months added also get that function (right now, I'd have to go in each month and add the new month to the list of columns being summed)? TIA
Tagged:
0
Answers
-
Solved my own issue with a Dynamic Unpivot
1
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
- 562 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