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.
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!
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!
That is so irritating it is not yet available. Should be fairly easy and will add so much value to reports everywhere.
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
Yup, I would love to have a rolling average option as well.
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.
Yes, please add this feature. This has been a request from our entire team
I submitted a similar idea here:
https://community.hubspot.com/t5/HubSpot-Ideas/Rolling-average-reporting/idi-p/837675
Hard to believe that between them there are so few upvotes.
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.