3 Replies Latest reply: Aug 8, 2016 7:07 AM by Supriya R RSS

    calculating Monthly Run Rate

    Supriya R

      Hi all,


      I have a table called useractivitylog table, where we store log_type_id= 2 as redirect


      table contians below column:


      user_activity_log_id, user_id, client_id, client_name, activity_start_time, activity_end_time, user_agent, status, log_type_id


      Now i want to calculate Monthly run rate for this 'log_type_id= 2' counts.


      What i have tried.



      in above equation i am getting count of  user_activity_log_id where log_type_id={'2'}.

      Now i need to calculate run rate monthly for log_type_id counts.



      How could i do this?