Analytics and reporting

Hi Randy,

Take a look at the example reports created for the Ad Hoc Queries plugin. There are many SQL code samples you can borrow from. This one combines course and user information, including city:

https://docs.moodle.org/32/en/ad-hoc_contributed_reports#Users_enrolled_in_a_course_with_groups_but_not_assigned_a_group

Best regards,

Elizabeth