Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Wrangle Summit 2021 On Demand

You can still experience the best people, ideas and technology in data engineering, all in one place

Get All-Access Pass
 
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

Transformations:
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 to Trifacta?

Sign up below to our free 30-day trial to use this template.

SIGN UP FOR FREE TRIAL

Already have an account?

Download template (Trifacta version) and import it on the Flows page.

Is your data on Google Cloud?

  1. Download template (Dataprep version)
  2. Launch Dataprep on Google Cloud
  3. Import it on Flows page

Learn more about Dataprep

How to Import