Lag
Shift a column downward.
Usage
Lag(field, offset, default)
field (required) A column of values to be shifted.
offset (optional) Distance, in rows, to shift. Must be an integer greater than 0. Defaults to 1 if an offset value isn’t provided.
default (optional) Default value for the first offset rows. Rows will be Null if a default isn’t provided.
Example
Lag([Quarter], 1)
- If Quarter has”Q1″,”Q2″,”Q3″and”Q4″, the Lag of 2 would be Null, “Q1”, “Q2” and “Q3”.
