Ruby on Rails 3 simple grouping and counting

Question

Say I have a 'Car' object which contains a 'color' column. I want in my view a listing of color with the number of times it has appeared.

---Car----Color--- Explorer Black Charger Yellow Prius Black Jetta Black Ferrari Red Pinto Yellow

In my view, I want:

--Color--Count-- Black 3 Yellow 2 Red 1

In my controller I tried making a list like:

@colorcount = Car.all.count(:group => :color)

and then in my view I have something like

<%= @colorcount.each do |car, count| %> <%= car.color %>, <%= count %> <% end %>

but I'm getting an error like:

undefined method `each' for 0:Fixnum

Is there a lot more to this? Thanks for any help.

zetetic · Accepted Answer · 2011-06-03 03:17:57Z

9

@groups = Car.count(:group=>:color) <% @groups.each do |color,count| %> <%= "#{color}, #{count}" %> <% end %>

answered Jun 3, 2011 at 3:17

zetetic

47.6k10 gold badges114 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

a3uge Over a year ago

I was close! The answer that got deleted also worked. Thanks to both of you. I added sorting by this: @groups = Car.count(:group => :color, :order => 'count_all DESC')

Collectives™ on Stack Overflow

Ruby on Rails 3 simple grouping and counting

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related