Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.anlytic.com/llms.txt

Use this file to discover all available pages before exploring further.

Calculates the moving count of values within a specified window of rows relative to the current row. Category: window Syntax: 
MovingCount([column], window_start, window_end)
Returns: Integer Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
columncolumn✓ YesThe column to count values 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.

​
Validation

  • Minimum parameters: 2
  • Maximum parameters: 3

​
Examples

MovingCount([Order_ID], -6, 0)
Returns the count of orders in a 7-day rolling window (current row and 6 previous rows). 
MovingCount([Customer_ID], -29, 0)
Calculates a 30-day moving count of customers, useful for tracking customer activity over time. 
MovingCount([Transaction_ID], -2, 2)
Calculates a centered 5-row moving count (2 rows before, current row, 2 rows after).
Last modified on March 13, 2026