Rolling 30 Day Formula in magic ETL
I am trying to write the formula above within magic ETL. Column A consists of static values. Column B starts with 0 as the first value and has the formula shown in the image. The formula resets its count every time it gets to a number greater than or equal to 30.
The only way I can find to do this is with a LAG() function that it appears is not available in DOMO.