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 |