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.
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
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive