magic ETL: Cummulative sum

odedbadt

Can anyone advise me on how to mimic the matlab or pandas "cumsum" function on a data set column in a magic ETL.

 

More accurately: the pandas groupby + cumsum functionality, that is to group by somecategorical cilumn and calculate the cummulative sum of a numeric value

 

Chronos

Is anyone able to help out with this request?

Gimli

Hello @odedbadt, 

This would be a great idea for a tile function in ETL. You can post this idea in our ideas exchange section. https://dojo.domo.com/t5/Ideas-Exchange/idb-p/Ideas

There is a great article in the knowledge base that will walk you through how to do this currently. 
The article is written for avg and is not currently broken up into a series. However, you can easily add a series.  http://knowledge.domo.com?cid=createrollingaverage