Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I think you don't get any answers because is difficult to understand your question
Try to read the 2 link or post a qvw, an excel with some source data and the expected output
HI
Are you looking for count of 'redirect' for the current month ?
count({<{">=$(=Num(MonthStart(Max(Datefield))))<=$(=Max(Datefield)"}>} redirect)
Hi,
i need to get run rate of redirect click counts.
Formula to calculate run rate of redirect click counts will be usefull