lag

Description

Return the lag of one column across an ordered group. Default ordering is ascending time, so the lag value is the most recent prior value

Return type

any

Domain

This is a window function (calculates over a group of multiple input rows using windowing.)

Categories

Usage

lag( expression, lagby )

Argument

Type

Required

Multiple

expression

any

Required

Only one

lagby

int64

Required

Only one