Moving Average

User interface

General Principles Add Missing Dates Add text column Add Total Rows Aggregate Append Compare Text Columns Argmax Argmin Concatenate columns Convert Convert date to text Convert text to date Cumulated sum Custom step Delete column(s) Geographically dissolve data Duplicate Duration Evolution Extract date information Extract substring Fill null Filter Formula Geographical hierarchy Get unique groups/values Hierarchical rollup ifthenelse Join Keep column(s) Moving Average Percentage Pivot Rank Rename Replace Geographical simplification Sort Split column Column's Statistics To lowercase To uppercase Top N rows Unpivot Waterfall

Technical documentation

Packages Steps Designing a new step Known limitations Variables UI components Custom code editor Python package

Compute Moving Average

Use this step to compute a moving average based on a value column, a reference column to sort (usually a date column) and a moving window (in number of rows). If needed, the computation can be performed by group of rows. The computation result is added in a new column.

This step is supported by the following backends:

Mongo 5.0
Mongo 4.2
Mongo 4.0
Mongo 3.6

Where to find this step?

Widget Compute
Search bar

Options reference

Value column:: the value column used as the basis for the moving average computation
Reference column to sort (usually dates): the column used to sort rows
Moving window (in number of rows): the number of rows included in the moving window
Group by (optional): if you want perform the computation by group of rows (see example 2 below)
New column name (optional): if you want to specify a custom column name (by default, it will be your original value column name suffixed with “_MOVING_AVG”)

Example 1: Basic usage

This configuration results in:

Example 2: with “group by” logic and custom new column

This configuration results in: