Syntax
GROUP_MOVING_AVERAGE(<number>;[<number><number>])
Values: time series values
K: number of past values to compute the moving average from
Description
This function smooths a time series by applying a simple moving average of the past k values. Smoothing a time series helps remove random noise and leave the user with a general trend. You might use GROUP_HOLT_WINTERS for exponential smoothing.
This is an aggregate function.
...
Click an empty column to bring up the Formula Builder (As of Datameer X v6.4, click the Fx button on the formula line to display the formula builder) and Builder and select GROUP_MOVING_AVERAGE
...
After having completed the workbook, a line chart would be a good tool to visualize your new smoothed data compared to your actual data.
...