CODEWITHSUNDEEP
ruby-on-railsrubychartsrailscastsmorris.js
Ryan.lay
Ryan.lay

Reputation: 1761

Rails Iteration by month given range of dates

I'm trying to follow this Railscast and create a morris.js line chart for my Enquiry model.

I've grouped the counts using date_trunc into months, but now I'm not quite sure at how to get the X-axis to iterate over months (e.g Jun 2012, Jul 2013) as opposed to by date as in the railscasts notes.

I've tried the range#step method here, but now the graph displays only one date (2012-07-01) without a count and nothing else. Commenting out the .step(1.month) method from the range variable and the graph works fine but the x-axis iterates by date.

class Enquiry < ActiveRecord::Base      

def self.chart_data(start = 1.year.ago)
    total_count = total_count_by_month(start)
    start = start.to_date.beginning_of_month
    today = Date.today.beginning_of_month
    range = (start..today).step(1.month)

      range.map do |month|
        {
          created_at: month,
          total_enquiries: total_count[] || 0
      }
    end
  end

  def self.total_count_by_month(start)
    enquiries = unscoped.where(created_at: start.beginning_of_month..Time.now)
    enquiries = enquiries.group("date_trunc('month', created_at)")
    enquiries = enquiries.select("date_trunc('month', created_at) as created_at, count(*) as count")
    enquiries.each_with_object({}) do |enquiry, counts|
      counts[enquiry.created_at.to_date] = enquiry.count
    end
  end
end

How do I get the chart's x-axis to iterate by months (Jun 2013, Jul 2013 ....) instead of by dates?

Upvotes: 1

Views: 3355

Answers (1)

Ryan.lay
Ryan.lay

Reputation: 1761

For anyone else facing the same problem, the solution is outlined below:

def self.chart_data(start = 1.year.ago)
    total_count = total_count_by_month(start)

    ##############################################
    start = start.to_date.beginning_of_month
    today = Date.today.beginning_of_month
    range = (start..today).select {|d| d.day == 1}
    ##############################################

    range.map do |month|
        {
          created_at: month,
          total_enquiries: total_count[] || 0
      }
    end
  end

The chart's x-axis now iterates by month.

The solution is found here.

I'm still looking for solutions on how the chart dates might display (%b %Y) as opposed to the current format of (yyyy-mm-dd).

Upvotes: 4

Related Questions