Trifacta wins the Best Data-Driven SaaS Product award at the 2021 Annual Cloud & SaaS Awards

Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Summer of SQL

A Q&A Series with Joe Hellerstein

See why SQL is Back
All Templates

Use Windows Functions to Compute Dips and Increases in Data Value Over Time

Window functions example Flow 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.


New user?

Use the buttons above and start your 30-day free trial. If your data is mostly on Google Cloud Platform, please use Dataprep. Otherwise, choose Trifacta.

Learn more about Dataprep