Skip to main content
Calculates the moving minimum value within a specified window of rows relative to the current row. Category: window Syntax:
Returns: Same as input type Context Filtering: ✓ Yes

Parameters

Allowed Column Types for column: INT, FLOAT, DECIMAL, NUMBER

Validation

  • Minimum parameters: 2
  • Maximum parameters: 3

Examples

Returns the lowest sales value in a 7-day rolling window (current row and 6 previous rows).
Calculates a 14-day moving minimum temperature, useful for tracking lowest temperatures over time.
Calculates a centered 9-day moving minimum (4 days before, current day, 4 days after).
  • CumulativeMin - Calculates cumulative minimum from the first row
  • MovingMax - Calculates moving maximum with a window
  • Min - Returns the overall minimum
Last modified on March 13, 2026