Median as an option for statistics

[KarolinaOlczak]

Hello 🙂

I use a lot of average options for statistics, but in our case, they are largely skewed due to accidental situations.

It would be great to be able to choose the median time to reply, the median time to close etc instead of average - it would help us to eliminate one-time situations affecting the vision of daily results. 

[KarolinaOlczak]

Hi Everyone!

I'm excited to share the news that when customizing or creating a report in the Single object builder or the Custom report builder, you will now find Median as an aggregation option for any number or date field type! Median can showcase the true middle and provide a more accurate representation of data distribution, without being adversely influenced by extreme values.

As always, thank you all for continuing to lend your voice and providing our product teams feedback on the features that are most important to you!

Best,

Kit

[craigshayowitz]

Same! My company has been using Median First Reply Time for 5 years and switched to HubSpot last week. It'd be great to continue reporting on our First Reply Time metric the way we always have!

[JustinTAnderson]

Same here,

I work for Unific.com and work exclusively with ecommerce clients. When we're dealing with groups of 1000+ contacts and trying to analyze segments, there can be high and low data values that really skew the Average.

In Excel I always do my analysis based on Median, but if HubSpot can add this option for reporting statistics then that allows me to give the clients more value within HubSpot without having to do an external Excel report.

-Justin Anderson

Ecommerce Data Analyst

[Mallikarjunan]

+1. Especially in Reports I'd love to be able to have Median as an option to plot rather than Average.

[JustinTAnderso1]

Yes. We work exclusively in ecommerce and when looking at stats like First Order Value, Days Between 1st and 2nd Order, Lifetime Order Value, seeing the average, alone, can really skew the interpretation due to 2-3 outliers in the data.

Having median as another option would mean the world for better customer insight and eliminate a lot of excel exporting or external reporting.

[JustinTAnderson]

I'm actually surprised this topic hasn't moved much since it was posted over a year and a half ago (and I can't find another thread that's higher-rated).

Given that HubSpot and marketing/sales are so data-driven, "Average" is completely not sufficient as a lone stat for what's typically happening in a group. We need "Median" to see the halfway point, or look at both number sets to get a picture of what's happening.

[andrulobruzzo]

Hi, when I create a report Hubspot helps me to count by total, average, maximum or minimum. But not median. This is important for me as When I want to calculate my sales cycle I don't want to do it by average as there might be an outlier deal that took too many time and balance up my averga. Median would be the right choice.  

[RSM]

Hope this is on the radar. Median makes so much more sense for most data.

[aviggiano]

This feature is desperately needed.

In the meantime, here's what I am doing to get a more accurate perspective of some variables on my Reports:

Here I want to have a grasp of my MRR distribution (like buckets to form a Histogram)

1- Create a custom property called "MRR distribution" with values such as < 1k, between 1k and 2k, etc.

2- Create a Workflow that, based on MRR, assigns each bucket on a if/else chain so that each Deal falls into a specific bucket

3- Then, create a chart using MRR distribution to see a histogram-like chart

 

[JustinTAnderson]

Aviggiano, wow, you've definitely figured out a serious work around here!

Obviously this isn't at all scalable, but I'm glad you've found a way to create 50/50 distributions in the meantime for key stats.

Again, this median reporting feature is desparately needed for accurate marketing intelligence. 

Cheers,

-J

[RSM]

Absolutely agree. It's so basic, yet powerful and required.

[alessandrob2d]

Yes, please add this posthaste! Thank you.

[ASpringer]

Same as above. For many measures a median can be more helpful than an average. 

[LDocherty]

Would love to see this added. 

[BrunAlbuquerque]

100% agreed!!!! 

[LDocherty]

Any update on this one? 

Would be very helpful. 

[BiancaSoima]

I noticed this is open since 2019 - I am sure it's not difficult to add and it would bring value to the reports.

[Justin_Anderson]

Hey y'all,

It's been 2 years since I first posted here and this still hasn't been implemented into the Report Builder.

"Average" is NOT sufficient as outliers commonly skew the data.

I work in ecommerce so I deal with a LOT of skew in large data sets.

We need "Median" to assess the true halfway point of what's happening.

(and while you're at it, please add "Mode" so we can also do some basic frequency analysis)

[Justin_Anderson]

Hey everyone, please take a moment and upvote THIS "Median option for Report statistics" feature request page instead: https://community.hubspot.com/t5/HubSpot-Ideas/Median-as-an-option-for-statistics/idc-p/691680#M1227...

It's the same feature request, but it has more comment and upvote traction. Let's get this in front of HubSpot to get this made! I seriously need this for my ecommerce clients!

[Justin_Anderson]

Bottom line is I get tired of exporting HubSpot data and analyzing it in Excel and just want to be able to send clients to an accurate HubSpot Dashboard. 🙏🏻😬

[TracyG]

Yes!! If we're all about data we need the right data. There are countless use cases where we need median over average