Best practice forum (Archived)

Tableau reports (sql queries)

 
LeversuchWendy
Tableau reports (sql queries)
LeversuchWendy 发表于 2019年05月3日 Friday 01:58
 

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)
Eves (Totara Support)Craig 发表于 2019年05月5日 Sunday 17:26
小组 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