Table quiz_submission_fact missing records?

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)


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.