# Add average rolling date range feature to reports

**URL:** <https://community.hubspot.com/t/add-average-rolling-date-range-feature-to-reports/51580>\
**Category:** HubSpot Ideas\
**Tags:** reports\
**Created:** [February 15, 2022, 4:51pm UTC](https://community.hubspot.com/t/add-average-rolling-date-range-feature-to-reports/51580 "2022-02-15T16:51:38Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![KPruett](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/kpruett/32/43872_2.png) [@KPruett](https://community.hubspot.com/u/KPruett)\
**Post date:** [February 15, 2022, 4:51pm UTC](https://community.hubspot.com/t/add-average-rolling-date-range-feature-to-reports/51580/1 "2022-02-15T16:51:38Z")

</div>

Would be great if HubSpot added averagte rolling date range to the reporting tool. For example, being able to see the 3 month average when looking at one month.

---

<div class="post-metadata">

**Author:** ![azalaquett](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/azalaquett/32/2490_2.png) [@azalaquett](https://community.hubspot.com/u/azalaquett)\
**Post date:** [February 15, 2022, 5:15pm UTC](https://community.hubspot.com/t/add-average-rolling-date-range-feature-to-reports/51580/2 "2022-02-15T17:15:35Z")

</div>

Yes, please! I have a Client where I have to monthly Export to Excel and use the Data Analysis tool -- would be great to eliminate this cumbersome step. Thank you!

---

<div class="post-metadata">

**Author:** ![KyleWinn](https://avatars.discourse-cdn.com/v4/letter/k/258eb7/32.png) [@KyleWinn](https://community.hubspot.com/u/KyleWinn)\
**Post date:** [February 15, 2022, 6:29pm UTC](https://community.hubspot.com/t/add-average-rolling-date-range-feature-to-reports/51580/3 "2022-02-15T18:29:33Z")

</div>

YES! Every Monday and at the end of the month I do analytical reports comparing week to week, month to month, and multiple month averages. Being able to see the comparison, averages, trends and what not would be huge!

---

<div class="post-metadata">

**Author:** ![1stClaas](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/1stclaas/32/75596_2.png) [@1stClaas](https://community.hubspot.com/u/1stClaas)\
**Post date:** [September 27, 2022, 10:02am UTC](https://community.hubspot.com/t/add-average-rolling-date-range-feature-to-reports/51580/4 "2022-09-27T10:02:28Z")

</div>

That is so irritating it is not yet available. Should be fairly easy and will add so much value to reports everywhere.

---

<div class="post-metadata">

**Author:** ![GrumpyHippo](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/grumpyhippo/32/19298_2.png) [@GrumpyHippo](https://community.hubspot.com/u/GrumpyHippo)\
**Post date:** [February 20, 2023, 7:27am UTC](https://community.hubspot.com/t/add-average-rolling-date-range-feature-to-reports/51580/5 "2023-02-20T07:27:00Z")

</div>

I would like to see a line graph which on a daily basis shows the average number of leads created over the previous X days.  
The timeframe for the graph might be Last 90 days, Last 180 Days, Last 365 days etc but the daily value of the metric being charted should be a rolling average of the previous X days.  
In addition, it should be possible to include various lines on a single chart, so I would be able to see for example on one graph:  
- Rolling averages of SQL over last 28 days  
- Rolling averages of New Customers over last 28 days

---

<div class="post-metadata">

**Author:** ![DRoeloffs](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/droeloffs/32/84335_2.png) [@DRoeloffs](https://community.hubspot.com/u/DRoeloffs)\
**Post date:** [September 18, 2023, 4:20pm UTC](https://community.hubspot.com/t/add-average-rolling-date-range-feature-to-reports/51580/6 "2023-09-18T16:20:01Z")

</div>

Yup, I would love to have a rolling average option as well.

---

<div class="post-metadata">

**Author:** ![LizG](https://avatars.discourse-cdn.com/v4/letter/l/e79b87/32.png) [@LizG](https://community.hubspot.com/u/LizG)\
**Post date:** [February 8, 2024, 2:41pm UTC](https://community.hubspot.com/t/add-average-rolling-date-range-feature-to-reports/51580/7 "2024-02-08T14:41:35Z")

</div>

We would love to have this available too so that our data is in one place and we’re not making Excel/Google Sheet charts too. This would be a huge value-add to HubSpot.

---

<div class="post-metadata">

**Author:** ![JTeblum](https://avatars.discourse-cdn.com/v4/letter/j/54ee81/32.png) [@JTeblum](https://community.hubspot.com/u/JTeblum)\
**Post date:** [September 5, 2024, 3:18pm UTC](https://community.hubspot.com/t/add-average-rolling-date-range-feature-to-reports/51580/8 "2024-09-05T15:18:12Z")

</div>

Yes, please add this feature. This has been a request from our entire team

---

<div class="post-metadata">

**Author:** ![GrumpyHippo](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/grumpyhippo/32/19298_2.png) [@GrumpyHippo](https://community.hubspot.com/u/GrumpyHippo)\
**Post date:** [September 6, 2024, 7:00am UTC](https://community.hubspot.com/t/add-average-rolling-date-range-feature-to-reports/51580/9 "2024-09-06T07:00:58Z")

</div>

I submitted a similar idea here:  
[https://community.hubspot.com/t5/HubSpot-Ideas/Rolling-average-reporting/idi-p/837675](https://community.hubspot.com/t5/HubSpot-Ideas/Rolling-average-reporting/idi-p/837675)  
Hard to believe that between them there are so few upvotes.

---

<div class="post-metadata">

**Author:** ![HakonXL](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hakonxl/32/44643_2.png) [@HakonXL](https://community.hubspot.com/u/HakonXL)\
**Post date:** [October 19, 2025, 10:18am UTC](https://community.hubspot.com/t/add-average-rolling-date-range-feature-to-reports/51580/10 "2025-10-19T10:18:30Z")

</div>

It is a great idea to add rolling / moving average in reports. Bar charts in Hubspot support linear and logarthimic trend lines. Moving average would be highly appreciated. For example a bar chart showing, sales results (total deal amounts) by week, month or quarter could benefit from a trend line that averages over the last N weeks, months or quarters. The functionality would show the overall trend dispite random spikes without the need to export data to Excel.
