Best practice forum (Archived)

Tableau reports (sql queries)

 
Wendy Leversuch
Tableau reports (sql queries)
by Wendy Leversuch - Friday, 3 May 2019, 1:58 AM
 

Hi All,

We have Totara linked up to tableau to do most of our reporting, which involves some sql quries (the published Totara scheme has been really useful for this).  Its working really well, but we're stuck on one report.

I have a course set up in Totara where each section (module) within the course has multiple quiz activities.  We're tying to pull the information so we can track progress on the course.

Does anyone know how the following tables link together?

mdl_course_modules_completion

mdl_quiz_attempts


Thank you!


Wendy

Craig Eves
Re: Tableau reports (sql queries)
by Craig Eves (Totara Support) - Sunday, 5 May 2019, 5:26 PM
Group Totara

Hi Wendy

The relationships between tables appear on the online schema - I looked at table_course_modules_completion and couldn't see a simple relationship -  the relationships look quite complex.

Is the completion data in the table mdl_course_modules

Regards