Table quiz_submission_fact missing records?

ryucali
Community Explorer

I was trying to create some analytics around quiz submissions across multiple courses, but I noted that quiz_submission_dim and _fact don't match. Delving deeper I find that submissions to quizzes that are not graded assignments are only included in the dim but not the fact table. (Some stats below)

ryucali_1-1621242080564.png

Is this an inherent bug in Canvas Data? Of course I can find those missing records in quiz_submission_historical_fact but just wanted to make sure if this insight is correct. 

 

0 Likes