Running Total with Magic ETL (not MySQL)

swagner

I've made this short video to explain what I'm trying to do:

GrantSmith

Hi @swagner 

 

You can use a Rank & Window Tile. Using SUM on your number field with an unbounded for the first setting and 0 for the last setting. Order by your date field and now partitions will get you a rolling sum / running total.

 

 

GrantSmith

Hi @swagner 

 

You can use a Rank & Window Tile. Using SUM on your number field with an unbounded for the first setting and 0 for the last setting. Order by your date field and now partitions will get you a rolling sum / running total.

 

 

swagner

Thanks Grant!

jaeW_at_Onyx

@swagner  in SQL parlance that's called a cumulative sum.

 

Which I mention because eventually you'll want to use a PARTITON BY which will reset your counter based on an Item, Customer or Year.