Moving Calculations

Feature Prerequisites

• 4.0 Version: If you are currently using version 3.0, you'll need to upgrade to 4.0 version to use this feature and other cool stuff.
• AQL-Enabled: Once your version is upgraded to 4.0, make sure you have enabled AQL for your datasets.

Alternative

This is the built-in, UI-centric functionality to calculate the Moving Calculations. Alternatively, you can use AQL expressions with the window functions as detailed here: AQL Window Functions.

The Moving Calculation feature is flexible and covers many common analytic use cases, such as:

• Drawing a moving average line to smooth out trends when there are wide fluctuations in your sales data;
• Calculating the cumulative total sales over time to keep track of how close you are to your sales target.

Moving Calculations are supported in various visualizations:

• Table
• Pivot table
• Line chart family including line, column, bar, area, and combination charts
• Metric sheet

You can learn more about how to use this feature in our tutorial video below: