Skip to main content
david_rudolph
david_rudolph
Contributor ⭐️⭐️
March 17, 2016
New Idea

Calculate the Median in Reports

Related products:CS Reports
  • March 17, 2016
  • 23 replies
  • 486 views
We would like to be able to calculate the median in reports. Currently, the aggregation options include: "Count, Count Distinct, Sum, Min, Max, Avg." In datasets comprised of extreme datapoints, average is not the best option to understand the data, median is a more reliable measure. In speaking with Support, it is currently not possible to calculate the median, but I think many would find this useful.

      23 replies

      Show previous replies
      sai_ram
      sai_ram
      Expert ⭐️⭐️
      March 17, 2021

      @jennycs did you get a chance view the comments here.

      jennycs
      jennycs
      Contributor ⭐️⭐️
      March 17, 2021

      Yes 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.

        andybuchanan
        andybuchanan
        Contributor ⭐️⭐️⭐️⭐️
        December 14, 2021

        This 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.

        Andy
          lyne_therien
          lyne_therien
          Helper ⭐️
          February 7, 2024

          Hello 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!

            sarahmiracle
            sarahmiracle
            VIP ⭐️⭐️⭐️⭐️⭐️
            May 10, 2024

            Pleeeeeeeeeeeeease add this capability 🙏🏻

            Customer Success Systems Admin @ Amplitude, 3x Gainsight CS Ops Product Council Member
              johntrask_bt
              johntrask_bt
              Helper ⭐️
              May 10, 2024

              I don’t think there is anything that would make my boss more happy then to see this. Please, can we see this in 2024?

              JohnTrask
                Stuart
                Stuart
                Helper ⭐️⭐️
                May 13, 2024

                8 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!)

                  romihache
                  romihache
                  VIP ⭐️⭐️⭐️⭐️⭐️
                  May 13, 2024

                  8 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! ☝

                  Continuous improvement is better than delayed perfection
                    nguruswamy
                    nguruswamy
                    Contributor ⭐️⭐️
                    June 5, 2024

                    It 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?

                      bfoleyHS
                      bfoleyHS
                      Contributor ⭐️⭐️⭐️⭐️
                      June 20, 2024

                      Please add this!

                      Show more replies
                      Terms & ConditionsAccessibility statement