Jago Brown

Reporting on Average course engagement (inc. Mobile)

Discussion created by Jago Brown on Apr 13, 2018
Latest reply on Jun 19, 2019 by Jago Brown

I’ve developed a crude report to provide the average number of student (CanvasData) requests for a course per day (over a 3 month period in query below)


(Total student course requests / active student enrolments) / number of days in requests record set, that students can access the course i.e. the course is published...


Can anyone spot any issue with my query below?


This is intended to provide an accurate total number of requests for each course in a canvas term:



PS I hope to add more on the report, later