Enable Moving Average

In DataTile, you can enable moving average for crosstab and dashboard charts.

Moving average in the Crosstab

Moving average provides the average value over a rolling period, which we define by entering the number of periods into a designated field.

To calculate the moving average in a crosstab,

• activate the MA button;

• enter the required number of periods in the field that appears;

• click CALCULATE.

If you don't see the Moving Average button, go to Project Settings → Settings → Features Availability, and tick the corresponding checkbox.

Moving average on the Dashboard

Here is how to use the Moving Average on a dashboard:

• Create an input control using the toolbar's ‘Add search control’ icon .

• Set the type of the control to ‘Integer’.

• Set the MIN and MAX values allowed for choosing and a default value.

• Assign the input control as the Moving Average (MA) to the chart widget.

• Switch to VIEW mode and enter the number in the input control.