Skip to content

Latest commit

 

History

History
28 lines (22 loc) · 891 Bytes

README.md

File metadata and controls

28 lines (22 loc) · 891 Bytes

d3.punchcard

Inspired by GitHub's punchcard, I created one to track information in my applications.

d3.punchcard

Footnote

While there is great tracking libraries and products, sometimes it's fun to do it yourself. If you wan't to track registrations for your app over the last week, you can do the following via Ruby on Rails and dump the data to this JavaScript file.

week = Time.now.beginning_of_week - 1.week
days = [week.strftime('%Y-%m-%d')]
1.upto(6) do |i|
  days << (week + i.days).strftime('%Y-%m-%d')
end

data = days.map do |day|
  by_hour = Array.new(24) { 0 }
  User.
    where('date(created_at) = ?', day).
    select('hour(created_at) as hour, count(*) as count').
    group('hour(created_at)').
    order('hour(created_at)').
    map { |user| by_hour[user.hour] = user.count }

  by_hour
end