Sum multiple values for the same Invoices
Hello,
I have a dataset that contains multiple rows of orders. I got an account number that represents the same client but the same client can have multiple orders. I would like to create a transformation that would SUM revenues and expenses that are all assigned to the same account number that represent 1 unique customer. In other words I want to sum up some values in different rows based on the same Account number. (I could do that from analyzer but I would really like to know how to create such transformation on the ETL level.
Thanks π
Best Answer
Answers
-
I would use a formula tile in magic ETL. You would also need to group by the account number. If you want the same number on each row, so you still have multiple rows I would branch this logic out and then join itself back.
1 -
@zuchu I think this will cover what you want to do. If not, can you provide an example screenshot (maybe in excel) of what the input looks like and output.
You can use the group by tile. In the "Select what columns identify the grouping" you would choose the account number.
In the new aggregated columns, you would choose the correct columns in your data set and choose the aggregation type of "Sum".
**Say βThanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 737 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive