Skip to main content
Calculates the moving average of values within a specified window of rows relative to the current row. Category: window Syntax: 
MovingAvg([column], window_start, window_end)
Returns: Float Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
columncolumn✓ YesThe numeric column to calculate moving average for
window_startinteger✓ YesThe number of rows before the current row to include in the window (negative value)
window_end✗ NointegerThe number of rows after the current row to include in the window (positive value). Defaults to 0.
Allowed Column Types for column: INT, FLOAT, DECIMAL, NUMBER

​
Validation

  • Minimum parameters: 2
  • Maximum parameters: 3

​
Examples

MovingAvg([Sales], -2, 0)
Returns the 3-day moving average (current row and 2 previous rows). 
MovingAvg([Temperature], -6, 0)
Calculates a 7-day moving average of temperature, useful for smoothing out daily fluctuations. 
MovingAvg([Stock_Price], -4, 4)
Calculates a centered 9-day moving average (4 days before, current day, 4 days after).
  • CumulativeAvg - Calculates cumulative average from the first row
  • MovingSum - Calculates moving sum with a window
  • Avg - Returns the overall average
Last modified on March 13, 2026