Magic ETL
Magic ETL
Adding Two Rows
I have a dataset listed below:
Year Gain Loss Net
1999 10 5 5
2000 15 20 -5
2001 12 9 3
2002 19 8 11
2003 17 21 -4
2004 18 3 15
I need to create a new column that has a sum of all active clients for that year:
Year Gain Loss Net Active
1999 10 5 5 5
2000 15 20 -5 0
2001 12 9 3 3
2002 19 8 11 14
2003 17 21 -4 10
2004 18 3 15 25
I can't seem to figure this out in ETL or BeastMode.
Welcome!
Best Answers
-
The running total optino should be there, see bellow.
If I had to do percent increased and so on I would try something that would use in part the method in this link
0 -
Sorry I should have been more specific.
In ETL it is part of the Rank & Window
Check out the way to use it in the knowledge base
0
Answers
-
Rather than a beastmode you could use the running total option in the card builder (General Chart Properties). That is the quickest, most stream line way. Depending on the card type and fields used it might not be available.
If you need to do it via ETL it becomes a tedious 10 step process. I saw a tutorial somewhere but never used myself.
0 -
I can't seem to find that in any of the cards. I actually need the data to calculate % gain and loss. I did find this article but it doesn't show me how to this for years.
0 -
The running total optino should be there, see bellow.
If I had to do percent increased and so on I would try something that would use in part the method in this link
0 -
Hi
Try the "Lead" function in ETL a combination of that plus an addition, repeated 5 times will definetely give you what you need (provided that your dataset is indeed that simple.
Cheers
0 -
This might be a dumb question but where is the "Lead" function?
I don't see it as one of the options.
0 -
Sorry I should have been more specific.
In ETL it is part of the Rank & Window
Check out the way to use it in the knowledge base
0 -
That worked!!!!
Thank you!!!!
0
Welcome!
Welcome!
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 46 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive