Moving average on Holistics

Hey everyone :wave:

Does anyone know how to visualise a moving average on Holistics charts.
In my dataset, I have a KPI per datetime. I want to group by month - year and do the sum which is straightforward but then have last 3 months average (of the summations).
Of course I could do it with SQL and a window function but I would prefer to avoid this.

Thanks !

Hi @Jordan_Peltier

We currently do not have support for visualizing moving averages. We will add your request to our backlog and notify you of any updates regarding this feature.

In the meantime, there are a couple of workarounds you could try:

  1. Use our transform model to calculate the moving average.
  2. Use our custom chart feature to draw the moving average. You can find more information on custom charts in our documentation here.

I hope this information proves helpful to you :smile: