Running Total with Magic ETL (not MySQL)

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

Best Answer

  • GrantSmith
    GrantSmith Indiana 🔴
    Accepted Answer

    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.


    Screen Shot 2020-12-09 at 11.09.04 AM.png



  • Thanks Grant!

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

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