# Ability to filter date post running total aggregation

**URL:** <https://community.holistics.io/t/ability-to-filter-date-post-running-total-aggregation/2150>\
**Category:** Ask the Community\
**Tags:** visualizations\
**Created:** [October 17, 2024, 12:32pm UTC](https://community.holistics.io/t/ability-to-filter-date-post-running-total-aggregation/2150 "2024-10-17T12:32:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jesko](https://community.holistics.io/letter_avatar_proxy/v4/letter/j/cdc98d/32.png) [@jesko](https://community.holistics.io/u/jesko)\
**Post date:** [October 17, 2024, 12:32pm UTC](https://community.holistics.io/t/ability-to-filter-date-post-running-total-aggregation/2150/1 "2024-10-17T12:32:48Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![tan](https://community.holistics.io/user_avatar/community.holistics.io/tan/32/358_2.png) [@tan](https://community.holistics.io/u/tan)\
**Post date:** [October 17, 2024, 1:11pm UTC](https://community.holistics.io/t/ability-to-filter-date-post-running-total-aggregation/2150/2 "2024-10-17T13:11:51Z")

</div>

Hi Jesko,

Can you try using the [running\_total | Holistics Docs (4.0)](https://docs.holistics.io/as-code/reference/running-total#definition) function with `keep_filters: false` and see if it works?

---

<div class="post-metadata">

**Author:** ![jesko](https://community.holistics.io/letter_avatar_proxy/v4/letter/j/cdc98d/32.png) [@jesko](https://community.holistics.io/u/jesko)\
**Post date:** [October 17, 2024, 2:40pm UTC](https://community.holistics.io/t/ability-to-filter-date-post-running-total-aggregation/2150/3 "2024-10-17T14:40:32Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![tan](https://community.holistics.io/user_avatar/community.holistics.io/tan/32/358_2.png) [@tan](https://community.holistics.io/u/tan)\
**Post date:** [October 18, 2024, 3:16am UTC](https://community.holistics.io/t/ability-to-filter-date-post-running-total-aggregation/2150/4 "2024-10-18T03:16:11Z")

</div>

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**

 ![CleanShot 2024-10-18 at 10.14.43@2x](https://community.holistics.io/uploads/default/original/2X/4/4d20dbbb09441bd6864d78ce81a75706bce415dd.png)

**With Filters**

 ![CleanShot 2024-10-18 at 10.12.43@2x](https://community.holistics.io/uploads/default/original/2X/d/d1fef68c782584104ac07307e7d287a502356189.png)
