There is already an aggregate function to get the average, but I don’t see a way to get the median of an aggregate. Being able to get the median would be helpful for me to have a better representation of where the “middle of the data” is, since outliers can significantly skew the average.
Looks like this one isn’t as straightforward as we’d like! https://stackoverflow.com/questions/1291152/simple-way-to-calculate-median-with-mysql
For now I’d recommend creating a custom resolver that enables the calculation.
1 Like