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

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.

  • 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.

    https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Rolling_Average_Using_DataFlows

  • 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  

  • This might be a dumb question but where is the "Lead" function?

     

    I don't see it as one of the options.

  • That worked!!!!

     

    Thank you!!!!