Ability to filter date post running total aggregation

[jesko]

We’d like to have an option to apply a date filter to a running total visualisation after the running total has been calculated.

For example, we may have registered user data going back to 2015 and we want to create a visualisation that shows a running total of registered users, however we only want to display the years 2020-2024 on the visualisation.

With the way this currently works it would only start calculating the running total from 2020, so it seems that what we need is the ability to apply a date filter to the final output/visualisation rather than the underlying dataset.

[tan (Tan Huynh)]

Hi Jesko,

Can you try using the running_total | Holistics Docs (4.0) function with keep_filters: false and see if it works?

[jesko]

Hi @tan, thanks for the quick reply, yes it looks like that is a good solution for running_total.

Is there something similar to keep_filters: false for trailing_period?

For example if we want to show a visualisation shows booking data quarterly, for each quarter a trailing 3 quarters, with the visualisation showing data for 2023 and 2024 but the trailing calculation ignoring that date filter?

Many thanks again!

[tan (Tan Huynh)]

The trailing_period function already works like that by default, so there isn’t an option to turn that on (or off for that matter)

You can see it in action here:
Without Filters

With Filters