Hi,
I am trying to find a report that can give me details for each course the number of users that have completed the course.
I have installed configurable reports plugin, but I am not able to find a way to get this report.
any help is appreciated.
figured out
SELECT c.shortname,
COUNT(p.timecompleted) AS TotalCompletions
FROM prefix_course_completions AS p
JOIN prefix_course AS c ON p.course = c.id
JOIN prefix_user AS u ON p.userid = u.id
GROUP BY p.course
ORDER BY c.shortname