---
title: "lag window function in Strata | Oplema"
description: "Get a value from an earlier row in a window, so each row can be compared with what came before it. Use it in a Strata Formula with an OVER clause."
url: "https://oplema.com/docs/strata/functions/lag"
updated: "2026-11-04"
---

# lag

Compare each row with a value from an earlier row.

## Try an expression

In [Formula](https://oplema.com/docs/strata/prep/formula), enter the expression and set Output type to **INTEGER**.

Example input

1. Row 1 `id = 1, amount = 10`
2. Row 2 `id = 2, amount = NULL`
3. Row 3 `id = 3, amount = 30`
4. Row 4 `id = 4, amount = 30`

### Expression

```
lag(amount) OVER (ORDER BY id)
```

### Result

```
Row 1: NULL
Row 2: 10
Row 3: NULL
Row 4: 30
```

NULL means the value is missing.

Try it live in Formula

Result
| id | amount | result |
| --- | --- | --- |
| 1 | 10 |  |
| 2 |  | 10 |
| 3 | 30 |  |
| 4 | 30 | 30 |

## Arguments and types

```
lag(expr[, offset[, default]][ ORDER BY ordering][ IGNORE NULLS])
```

The result type can depend on the input types. See DuckDB for the full argument rules.

## Things to know

ORDER BY defines the order used by the calculation; it doesn't sort the output table. Include a unique tie-breaker when row position matters. Window expressions belong in Formula and can't be entered directly in Filter.

Missing values occupy positions by default. The first row has no previous value, so this example returns NULL there.

## Related functions

[lead

Compare each row with a value from a later row.

](https://oplema.com/docs/strata/functions/lead)[cume\_dist

Find the fraction of rows whose sort value is less than or equal to the current value.

](https://oplema.com/docs/strata/functions/cume-dist)[first\_value

Repeat the first value in a window frame.

](https://oplema.com/docs/strata/functions/first-value)[last\_value

Repeat the last value in a window frame.

](https://oplema.com/docs/strata/functions/last-value)

[Browse across rows](https://oplema.com/docs/strata/functions#across-rows) [DuckDB documentation](https://duckdb.org/docs/current/sql/functions/window_functions.html#lagexpr-offset-default-order-by-ordering-ignore-nulls)

Function metadata from DuckDB, used under the [MIT license](https://github.com/duckdb/duckdb/blob/v1.5.4/LICENSE).
