# "Rolling Period" for "Running Total"

**URL:** <https://community.holistics.io/t/rolling-period-for-running-total/801>\
**Category:** Feature Suggestions\
**Created:** [March 8, 2022, 2:22pm UTC](https://community.holistics.io/t/rolling-period-for-running-total/801 "2022-03-08T14:22:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hyun](https://community.holistics.io/letter_avatar_proxy/v4/letter/h/6a8cbe/32.png) [@Hyun](https://community.holistics.io/u/Hyun)\
**Post date:** [March 8, 2022, 2:22pm UTC](https://community.holistics.io/t/rolling-period-for-running-total/801/1 "2022-03-08T14:22:03Z")

</div>

e.g. in BigQuery,

```auto
select
  date,
  cnt_booking,
  sum(cnt_booking) over (order by unix_date(date) range between 06 preceding and current row) as cnt_booking_last_07_days,
  sum(cnt_booking) over (order by unix_date(date) range between 27 preceding and current row) as cnt_booking_last_28_days,
from (
  select
    date,
    count(1) as cnt_booking,
  from
    booking
  group by
    date
)
order by
  date

```

Our team usually tracking metrics in rolling period (7 days, 28 days),  
To neutralize effects of seasonality.

So it would be great, if we can set rolling period in running total.

---

<div class="post-metadata">

**Author:** ![Khai\_To](https://community.holistics.io/user_avatar/community.holistics.io/khai_to/32/128_2.png) [@Khai\_To](https://community.holistics.io/u/Khai_To)\
**Post date:** [March 9, 2022, 3:52am UTC](https://community.holistics.io/t/rolling-period-for-running-total/801/2 "2022-03-09T03:52:41Z")

</div>

Hi @Hyun,

Thank you for the suggestion. For now we don’t support rolling period yet but I do believe this option will be useful for a lot of users who’re using our running total feature. I will let you know when there is an update.

---

<div class="post-metadata">

**Author:** ![Hyun](https://community.holistics.io/letter_avatar_proxy/v4/letter/h/6a8cbe/32.png) [@Hyun](https://community.holistics.io/u/Hyun)\
**Post date:** [March 10, 2022, 5:08am UTC](https://community.holistics.io/t/rolling-period-for-running-total/801/3 "2022-03-10T05:08:40Z")

</div>

> I will let you know when there is an update.

thanks.

---

<div class="post-metadata">

**Author:** ![Phuong\_N\_Holistics](https://community.holistics.io/user_avatar/community.holistics.io/phuong_n_holistics/32/1420_2.png) [@Phuong\_N\_Holistics](https://community.holistics.io/u/Phuong_N_Holistics)\
**Post date:** [October 16, 2024, 2:57am UTC](https://community.holistics.io/t/rolling-period-for-running-total/801/4 "2024-10-16T02:57:51Z")

</div>

Hi @Hyun

Our new feature **Moving Calculations** can help with your rolling period use cases. Please give it a try and let us know if you have any feedback or questions 🙂

For more details, please check out our doc here: [Moving Calculations | Holistics Docs 4.0](https://docs.holistics.io/docs/moving-calculation)

[https://cdn.holistics.io/product/reporting-moving-calculations-short-video-20240830-220.mp4](https://cdn.holistics.io/product/reporting-moving-calculations-short-video-20240830-220.mp4)