Details

    Description

      When analyzing skewed data, median can be a better measure than mean.

      Currently this can be implemented with a User Defined Function (e.g. http://www.mooreds.com/wordpress/archives/376), however this requires more overhead when upgrading and deploying database. This can also be handled with a query (e.g. http://stackoverflow.com/questions/1291152/simple-way-to-calculate-median-with-mysql), however that has a performance hit.

      Would adding a new aggregate function be possible?

      Attachments

        Issue Links

          Activity

            When we'll be implementing it, it should probably be not MEDIAN(), but a more generic PERCENTILE().

            serg Sergei Golubchik added a comment - When we'll be implementing it, it should probably be not MEDIAN(), but a more generic PERCENTILE().

            This is duplicate of MDEV-12985

            dshjoshi Dipti Joshi (Inactive) added a comment - This is duplicate of MDEV-12985
            mokraemer Marc added a comment -

            @Sergei: why would you want to name it "PERCENTILE". Everybody know the mathematic function name median, so everybody will search it by that name.
            But I'm hoping for that function to be integrated too.

            mokraemer Marc added a comment - @Sergei: why would you want to name it "PERCENTILE". Everybody know the mathematic function name median, so everybody will search it by that name. But I'm hoping for that function to be integrated too.

            Done. Both PERCENTILE and MEDIAN. See MDEV-12985

            serg Sergei Golubchik added a comment - Done. Both PERCENTILE and MEDIAN. See MDEV-12985
            jan.reges Ján Regeš added a comment -

            Thank you Sergei!

            It's like a Christmas present ))

            jan.reges Ján Regeš added a comment - Thank you Sergei! It's like a Christmas present ))

            People

              varun Varun Gupta (Inactive)
              BenHiles Ben Hiles (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.