Skip to content

Instantly share code, notes, and snippets.

@all4miller

all4miller/average_time_in_hours_to_2_or_more_views_fast.rb

Created April 1, 2021 17:05
Show Gist options
  • Save all4miller/67ec5959a57cffc93197a79fbb77b0ef to your computer and use it in GitHub Desktop.
Save all4miller/67ec5959a57cffc93197a79fbb77b0ef to your computer and use it in GitHub Desktop.
Download ZIP
Raw
average_time_in_hours_to_2_or_more_views_fast.rb
def average_time_in_hours_to_2_or_more_views
Businesss.where.not(date_achieved_2_views: nil).pluck('sum(abs(extract(epoch from created_at - date_achieved_2_links)/3600)) / count(*)').first
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment