The Instructure Community will enter a read-only state on November 22, 2025 as we prepare to migrate to our new Community platform in early December. Read our blog post for more info about this change.
Found this content helpful? Log in or sign up to leave a like!
The schema says quiz_submission_historical_dim contains "Attributes for all submitted quizzes" which lead me to believe I would be able to find the dates of each submission. However, at least in our data, the only items in this table with data in the "finished_at" column (or any of the other date colums) is the most recent submission. It is the same date as the corresponding submission_dim and quiz_submission_dim which the docs indicate will only contain the most recent submission.
My question is, is this working as intended? In other words, does only the most recent date appear by design, or is there something going on with our instance?
My follow up question would be, if so, why? We have a need to determine when each attempt was submitted and I cannot think of a reason this data would not be available somewhere. Is there something else I'm missing?
Thanks
That's how the quiz_submission_historical_dim works for us too. It retains the timestamp for the kept attempt only. You can get the timestamps for each attempt by downloading the Student Analysis csv from Quiz Statistics but you can only do that one quiz at a time.
Community helpTo interact with Panda Bot, our automated chatbot, you need to sign up or log in:
Sign inTo interact with Panda Bot, our automated chatbot, you need to sign up or log in:
Sign in