magic ETL: Cummulative sum

odedbadt · November 2017

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 · November 2017

Is anyone able to help out with this request?

ilikenno · November 2017

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

magic ETL: Cummulative sum

Comments

Categories