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.

       

      count({$<log_type_id={'2'}>}user_activity_log_id)

      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?