Moving average on Holistics

Hi @Jordan_Peltier,

We have officially supported Moving Average (or Rolling Average) via our AQL Expression.

You can refer to our doc here for more details < Moving Average | Holistics Docs>.

Basically, we have a function trailing_period() that calculates for a specific number of date periods up to the current period.

For example, you can apply this computation to determine the total orders you have in the last 3 months up until the current month, also known as Trailing 3 Months Metric.

Do let us know if you have any questions or concerns.