How to Group by Day with Ruport / Ruby on Rails?

Question

I'm trying to evaluate Ruport for use in my Rails app, but am not sure how to take a series of records with date/time stamps and group them via Ruport's grouping functions.

I'm open to other/better methods to do this same grouping if Ruport doesn't make sense.

did you decide to go without ruport for this? I'd like to be able to do this with ruport — Satchel, Jun 16 '10 at 00:55

score 6 · Accepted Answer · answered Sep 15 '09 at 07:06

6

Without ruport:

<% @posts.group_by {|p| p.created_at.at_beginning_of_day }.each do |day, posts| %>
  <h2><%= day.strftime("something...") %></h2>

  <% posts.each do |post| %>
    do stuff with `post`.
  <% end %>
<% end %>

Use at_beginning_of_month, at_beginning_of_week and so on, depending on what you want to group by.

answered Sep 15 '09 at 07:06

August Lilleaas

54,010
13
102
111

This helped me to much right now. Thanks! I wish I could upvote it a few more times. – Joost Schuur Oct 07 '10 at 02:17

score 2 · Answer 2 · answered Jun 16 '11 at 03:32

Ruport includes a method to add a new column to a table. So date wise grouping from a timestamp source can be done like this:

@table.add_column('created_at_date') { |r| r.created_at.to_date }
created_at_date_grouping = Grouping(@table, :by => "created_at_date")

This method can, of course, also be used to generate more interesting reports like on Google Analytics:

@table.add_column('day_of_week') { |r| r.created_at.strftime('%a') }
@table.add_column('hour_of_day') { |r| r.created_at.strftime('%H') }

Don't know about performance though.

score 1 · Answer 3 · answered Sep 16 '09 at 14:13

1

I would suggest moving the @posts.group_by function into the controller rather than the view.

answered Sep 16 '09 at 14:13

mike_wags

43
4

How to Group by Day with Ruport / Ruby on Rails?

3 Answers3