magic ETL: Cummulative sum

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

Find more posts tagged with

Comments

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

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of