The flow view of this template
window functions (prev, next), select
This flow example shows how you can use window functions prev and next to compute value differences between current row vs the previous row, or current row vs the next row. This is a very common use case when you need to calculate dips and increases over different granularities of time.
For more information, please see transformation function documentation for prev and next.