Please, for the love of all things statistics and reporting, allow the ability for averages in a report!
We are trying to see not only our demos booked and completed for a certain time frame, but the running average of demos booked. That way, we can easily see if we are above or below average and what may be attributed to this!
It's very important for us to see at a glance, and I can't believe something as robust as Hubspot wouldn't have this capability. Please please please make this happen! 🙂
We appreciate the feedback. It is possible to apply an average to a report using the new Custom Report Builder [In Beta]. The Custom Report Builder supports 20+ data sources from marketing, sales, and service, and has increased functionality and new visualizations. It is now available to all Professional and Enterprise customers. You can access it directly in your portal using this link.
Averages can be applied to eligible metrics (numeric fields) in the custom report builder. To apply an average to your report, start by searching for the field you are looking for in the field select within the far left panel. Use the drag-and-drop functionality to add your desired metric directly to the Y-Axis of your report. You can identify numeric fields with the "#" sign, far left. Once the field is in the Y-Axis, you can click on the field to access the aggregation options: distinct count, sum, average, min, max.
Screenshot of average below:
You can use filters to narrow down your desired time range or other criteria. This should solve for the majority of use cases mentioned in the thread, but open to additional questions or feedback about applying averages.
Product team @ HubSpot
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.