Calculate the Median in Reports
On the second thought, simple formula field would suffice:
Formula: (Sum of XY / Sum of AB) / 100
+1
+5
We are now looking for using the Median. It looks like it was added to the roadmap 4 years ago. Exactly how far ahead does your roadmap go, if something on the roadmap doesn’t get implemented for at least 4 years?
+2We did deliver the Median calculation for column calculations. The rest of the part, i.e. median aggregation was deprioritized for a few more impactful features such as Formula Fields. Today you would have to rely on one of our data prep flows (Data Designer and Rules Engine) to compute the median for the data.
+1+1Okay - The articles point to the NXT platform, but we are on SFDC, but I see the COLUMN calculation for Median, but we want it for Aggregation - like Average or Sum. Can we upvote this item and request it for Aggregation, not column calculation?
Is there something in Vault or best practices that could help me to built this using Rules Engine - assuming I am building a separate MDA Object to store the Median values and recalculate it each day? I haven’t found anything yet.
My COM said that he would enable Beta access for new Horizon Reporting capabilities. Will I find Median in the new reporting?
+2Hi
While we have median as a column total and in data preparation, we do not have it as aggregation in the existing reporting. This also will not be present in the new reporting.
We have it as a backlog item and will prioritize based on the upvotes requests for this ask.
+1Yes I did - No solution yet in reporting, upvotes are not so high, so probably won’t get implemented soon. and assume that the solution is as I stated above - build an MDA object and a rule to calculate it each day.
+2This is really a bummer. Avg is not a true representation of things like First Time to Value or other things as there are extremes on either end that skew too widely. Looks like this has been a gap since the beginning, really tough to sell to execs that we can’t build a filterable median metric into reports / dashboards.
+1Hello Gainsight people. The first post on this conversation was 7 years ago. Are you making progress on making “Median” part of the aggregation choices for Gainsight? Thanks!
+11Pleeeeeeeeeeeeease add this capability 🙏🏻
+5I don’t think there is anything that would make my boss more happy then to see this. Please, can we see this in 2024?
+38 years ago this was raised?!? 😳 Wholeheartedly agree with this; indeed, “average” (read AVG in the Gainsight reporting) really isn’t explicit enough, and Gainsight should have support for the three main statistical averages - mean, mode and median (and replace the term AVG at the same time!)
+98 years ago this was raised?!? 😳 Wholeheartedly agree with this; indeed, “average” (read AVG in the Gainsight reporting) really isn’t explicit enough, and Gainsight should have support for the three main statistical averages - mean, mode and median (and replace the term AVG at the same time!)
THIS! ☝
+1It is really painful to try to force getting the Median calculated via Data Designer and leads to delayed data for reporting. Teams are having to do this calculation manually outside of the tool. When will this feature be prioritized?
+3Please add this!
+2This is something our teams have asked for as well. Having it be possible in Gainsight would be really helpful.
This has recently come up at as something needed for a report. I would love the additional functionality.
Would love to see this! It’s very painful to have to do this in a (very slow, timing-dependent) data designer or outside of Gainsight. Pretty shocking that this was raised 9 years ago and has over 50 votes. Seems like it’d be an easy QOL change
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.