Reporting on Average course engagement (inc. Mobile)

jago_brown
Community Member

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:

272995_pastedImage_1.png

PS I hope to add more on the report, later

Jago