Median for ActiveRecord - PostgreSQL only at the moment
Item.median(:price)
Works with grouping, too.
Order.group("date_trunc('week', created_at)").median(:total)
Add this line to your application’s Gemfile:
gem "active_median"
And add the median
function to the database from the Rails console.
ActiveMedian.create_function
- Fork it
- Create your feature branch (
git checkout -b my-new-feature
) - Commit your changes (
git commit -am 'Add some feature'
) - Push to the branch (
git push origin my-new-feature
) - Create new Pull Request