I’m working on getting the assignment submission information into Starfish Early Alert system using Canvas Data. I'm working with submission_dim and submission_fact trying to generate some data based on student submissions. I see in the schema that submission_dim and submission_fact both have only information about the LATEST submission.
If there are multiple submisisons for an assignment/student/course:
I see the number of attempts but I can't find the first attempt date or timestamp. There seems to be no way to see past submission information for assignments in canvas data - it only keeps the most recent submission's data. I was advised by canvasdatahelp to submit this as a feature idea.
Could submissions_dim have a field added that includes the FIRST ATTEMPT DATE for the assignment?