find-the-outliers.rb

time_zone = '<YourTimezone>'
account_id = '<YourAccountID>'

start_date = Time.zone.now - 12.days
end_date = Time.zone.now

a = Account.find(account_id)


outlier_events = a.reporting_events.where(created_at: start_date..end_date, name: 'conversation_resolved').order(value: :desc).limit(30)
outlier_events.each do |event|
  puts "Conversation ##{event.conversation.display_id}, created on #{event.conversation.created_at.strftime('%Y-%m-%d')} took #{(event.value / 1.day).round(0)} days"
end