Databases
StackOverflow2013
Postsdbo
POHow to calculate users response rate and time
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to calculate users response rate and time
    primarykey
    data
    text
    <p>I have been trying to brainstorm on how I can calculate a users response rate (% of responses to messages received) and time (how fast does user responds to messages). This information would show on a users profile. I can't think of a formula that would work for this and haven't seen any other posting regarding it.</p> <p>For example User A response rate is 85% and their response time is 3 days. What would be the proper way to attack this? </p> <p>Messages model:</p> <pre><code> attr_accessible :subject, :body, :sender_id, :recipient_id, :read_at,:sender_deleted,:recipient_deleted validates_presence_of :subject, :message =&gt; "Please enter message title" has_many :notifications, as: :event scope :unread, -&gt; {where('read_at IS NULL')} belongs_to :sender, :class_name =&gt; 'User', :foreign_key =&gt; 'sender_id' belongs_to :recipient, :class_name =&gt; 'User', :foreign_key =&gt; 'recipient_id' # Based on if a message has been read by it's recipient returns true or false. def read? self.read_at.nil? ? false : true end def self.received_by(user) where(:recipient_id =&gt; user.id) end def self.not_recipient_deleted where("recipient_deleted = ?", false) end def self.sent_by(user) Message.where(:sender_id =&gt; user.id) end </code></pre> <p>Controller:</p> <pre><code> before_filter :set_user def index @messages = Message.scoped @message = Message.new if params[:mailbox] == "sent" @messages = @user.sent_messages.paginate :per_page =&gt; 10, :page =&gt; params[:page], :order =&gt; "created_at DESC" elsif params[:mailbox] == "inbox" @messages = @user.received_messages.paginate :per_page =&gt; 10, :page =&gt; params[:page], :order =&gt; "created_at DESC" #elsif params[:mailbox] == "archived" # @messages = @user.archived_messages end if params[:mailbox] == "unread" @messages = @user.unread_messages.paginate :per_page =&gt; 10, :page =&gt; params[:page], :order =&gt; "created_at DESC" end if params[:mailbox] == "trash" @messages = @user.deleted_messages.paginate :per_page =&gt; 10, :page =&gt; params[:page], :order =&gt; "created_at DESC" end end def new @message = Message.new @message.conversation_id = params[:conversation_id] end def create @message = Message.new(params[:message]) @message.sender_id = @user.id if @message.save flash[:notice] = "Message has been sent" redirect_to user_messages_path(current_user, :mailbox=&gt;:inbox) else render :action =&gt; :new end end def show @reply_message = Message.new @message = Message.find(params[:id]) if @message.recipient == current_user UserMessageWorker.perform_async(@message.id, current_user.id) end @message.readingmessage if @message.recipient == current_user end def reply @reply_message = Message.new @message = Message.new @message.conversation_id = params[:conversation_id] end def destroy @message = Message.find(params[:id]) @message.destroy flash[:notice] = "Successfully deleted message." redirect_to user_messages_path(@user, @messages) end def delete_multiple if params[:delete] params[:delete].each { |id| @message = Message.find(id) @message.mark_message_deleted(@message.id,@user.id) unless @message.nil? } flash[:notice] = "Messages deleted" end redirect_to user_messages_path(@user, @messages) end def update @message = Message.new if params[:reply_to] @reply_to = User.find_by_id(params[:reply_to]) unless @reply_to.nil? @message.recipient_id = @reply_to.id end end end private def set_user @user = current_user end end </code></pre> <p>Log:</p> <pre><code>2014-02-05T17:08:16Z 33906 TID-zt6cxk WARN: {"retry"=&gt;true, "queue"=&gt;"default", "class"=&gt;"UserMessageWorker", "args"=&gt;[159, 2], "jid"=&gt;"f502221628588feaa5efa7d3", "enqueued_at"=&gt;1391619720.3566332, "error_message"=&gt;"undefined method `messages' for #&lt;User:0x00000101edb0a0&gt;", "error_class"=&gt;"NoMethodError", "failed_at"=&gt;"2014-02-05T17:02:00Z", "retry_count"=&gt;4, "retried_at"=&gt;2014-02-05 17:08:16 UTC} 2014-02-05T17:08:16Z 33906 TID-zt6cxk WARN: undefined method `messages' for #&lt;User:0x00000101edb0a0&gt; 2014-02-05T17:08:16Z 33906 TID-zt6cxk WARN: /Users/.rvm/gems/ruby-2.0.0-p353/gems/activemodel-4.0.0.rc1/lib/active_model/attribute_methods.rb:436:in `method_missing' /Users/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.0.rc1/lib/active_record/attribute_methods.rb:131:in `method_missing' /Users/dating/app/workers/user_message_worker.rb:8:in `perform' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/processor.rb:49:in `block (3 levels) in process' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/middleware/chain.rb:122:in `call' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/middleware/chain.rb:122:in `block in invoke' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/middleware/server/active_record.rb:6:in `call' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/middleware/chain.rb:124:in `block in invoke' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/middleware/server/retry_jobs.rb:62:in `call' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/middleware/chain.rb:124:in `block in invoke' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/middleware/server/logging.rb:11:in `block in call' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/logging.rb:22:in `with_context' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/middleware/server/logging.rb:7:in `call' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/middleware/chain.rb:124:in `block in invoke' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/middleware/chain.rb:127:in `call' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/middleware/chain.rb:127:in `invoke' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/processor.rb:48:in `block (2 levels) in process' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/processor.rb:105:in `stats' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/processor.rb:47:in `block in process' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/processor.rb:86:in `do_defer' /Users/.rvm/gems/ruby-2.0.0-p353/gems/sidekiq-2.17.2/lib/sidekiq/processor.rb:37:in `process' /Users/.rvm/gems/ruby-2.0.0-p353/gems/celluloid-0.15.2/lib/celluloid/calls.rb:25:in `public_send' /Users/.rvm/gems/ruby-2.0.0-p353/gems/celluloid-0.15.2/lib/celluloid/calls.rb:25:in `dispatch' /Users/.rvm/gems/ruby-2.0.0-p353/gems/celluloid-0.15.2/lib/celluloid/calls.rb:122:in `dispatch' /Users/.rvm/gems/ruby-2.0.0-p353/gems/celluloid-0.15.2/lib/celluloid/actor.rb:322:in `block in handle_message' /Users/.rvm/gems/ruby-2.0.0-p353/gems/celluloid-0.15.2/lib/celluloid/actor.rb:416:in `block in task' /Users/.rvm/gems/ruby-2.0.0-p353/gems/celluloid-0.15.2/lib/celluloid/tasks.rb:55:in `block in initialize' /Users/.rvm/gems/ruby-2.0.0-p353/gems/celluloid-0.15.2/lib/celluloid/tasks/task_fiber.rb:13:in `block in create' </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USpwz2000
    1. USpwz2000
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to calculate users response rate and time
      1. USpwz2000
      1. VTBountyStart
    2. VO
      singulars
      1. POHow to calculate users response rate and time
      1. USStuart
      1. VTFavorite
    3. VO
      singulars
      1. POHow to calculate users response rate and time
      1. This table or related slice is empty.
      1. VTUpMod
    1. COso you're sending users, from an email, back to your website, and you want to calculate the elapsed interval, response rate emails to people that view that page?
      singulars
      1. POHow to calculate users response rate and time
      1. USrogerdpack
    2. COFor the registered users I was unable to create a formula/code that would calculate their response rate to received messages (unread). It should show response rate is % and response time is x days. For example on https://www.airbnb.com/rooms/1349952 it shows response rate and time under their contact information.
      singulars
      1. POHow to calculate users response rate and time
      1. USpwz2000
    3. COhow do you determine that one message is a response to another?
      singulars
      1. POHow to calculate users response rate and time
      1. USMike Campbell
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload