ruby on rails - Ankane GroupDate issue with .minimum .maximum

Question

Using this gem https://github.com/ankane/groupdate I'm having issue when using anything else than .count

I have products where I store the price value every few hours in a PriceHistory table. The following query is working (Counting the number of price_histories for each day)

Product.first.price_histories.group_by_day(:created_at, range: 7.days.ago..Time.now).count

But this one is not (I'm trying to get the minimum price for each day)

Product.first.price_histories.group_by_day(:price, range: 7.days.ago..Time.now).minimum

How could I do that with or without the gem ?

Thanks

Answer 1

The query was not correct it should have been

Product.first.price_histories.group_by_day(:created_at, range: 7.days.ago..Time.now).minimum(:price)