Moving average on Holistics

Ask the Community
1

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 !

2

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:

3

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.

image
image1067×785 81.5 KB

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

4

Hi @Jordan_Peltier

Besides the AQL route, you now can quickly create a moving average trend line with our point-and-click Moving Calculations! :partying_face:

For more details, please check out our doc here: Moving Calculations | Holistics Docs 4.0

5

Sadly not because we are still on version 3.0 :smiling_face_with_tear:

6

@Jordan_Peltier perhaps it’s time to upgrade to 4.0? :smile:

We already have bunch of amazing features exclusively in the 4.0 such as as-code everything, canvas dashboard with themes, quick-and-easy analytic functions like percent of total and moving calculations,… and many more cool stuff to come!

We’d love to show you what our 4.0 can do in action :blush: Would you be interested in a 30-minute demo call? If yes, please input your preferred time here: Schedule a demo

You can also try out our simplified 4.0 version in our playground as well: Holistics Playground

7

Price is the main blocker for now as we would like to not increase our monthly budget for BI viz tool

8

That’s unfortunate :crying_cat_face:

We hope your monthly budget for BI tool would increase sometime soon, so we could have a chance to serve you and your team with our new amazing version!