I would like to be able to create line graphs which on a daily basis shows for example 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
Is there any news on this capablity HubSpot? I’m trying to create a rolling average too and it doesn’t seem possible with any of the report formats I’ve tried!
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.
Really surprised that after 2 years this still only has 9 upvotes. I think it is the single biggest issue for us in terms of Hubspot reporting