Gathering Data on Assigments that don't have a submission type?

JasonBrandt

We are working on some data models to be displayed in PowerBI. I have a question regarding assignments when there is not a submission type, the assignment table will have a value of None. So, I can calculate the number of assignments submitted by student from the submissions table if the assignment has a submission type. Where would I get the data that someone "submitted" an assignment when there isn't a submission? I hope that makes sense!

Jeff_F

@JasonBrandt 

As students are not posting anything to Canvas perhaps look at the Submissions table Graded At and Grade fields. If these are not null then you could assume that the instructor 'gathered' what was needed to assess some aspect of the student and then entered a grade into the Grades.  

So something like COUNTD ID (submissions) if x and/or y are not null.