Ad - Hoc Reports Creating User Cumulative Time Spent in Site

Re: Ad - Hoc Reports Creating User Cumulative Time Spent in Site

by Luis de Vasconcelos -
Number of replies: 1
Just remove the "l.courseid = %%COURSEID%% condition" and it should give you a sitewide report.

# CHANGE UserID
- WHERE l.userid = %%USERID%% AND l.courseid = %%COURSEID%%
+ WHERE l.userid = %%USERID%%
%%FILTER_STARTTIME:l.timecreated:>%% %%FILTER_ENDTIME:l.timecreated:
Average of ratings: Useful (1)
In reply to Luis de Vasconcelos

Re: Ad - Hoc Reports Creating User Cumulative Time Spent in Site

by Ahmad Nugroho -

Hello Luis , Thank you for your feedback,


i see so when i delete l.userid it wil show sitwide report ?



Average of ratings: -