This post is part of the series, Deep Dive.
Construct’s Transform node has dozens of built-in functions that help you perform calculations and create new variables. But did you know the Transform Node also has some secret functions?
In this deep dive webinar, we’ll share a function that you won’t find in the function list: the Rolling Sum Function. Rolling Sum displays a sum of values row by row in a column instead of total column sum; it’s a great tool for benchmarking progress. We’ll also cover the lesser-known Lag Function and discuss local variables you can use within your transform formulas to simplify your code.
Tune into this deep dive as we share:
- An overview of the rolling sum function
- When to use the lag function
- How to use local variables to simplify your code
Scroll down to watch the on-demand video!