Function Index

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.

Examples

Lag([Quarter], 1)
  • If Quarter has”Q1″,”Q2″,”Q3″and”Q4″, the Lag of 2 would be Null, “Q1”, “Q2” and “Q3”.