Community

mjellings · ‎08-05-2022

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

smhickey · ‎02-02-2017

As an instructor, I have accidently deleted student discussion posts many times in the past. Several of my students have done the same. There is no warning/confirm messsage and there is no way to recover a deleted discussion post in the event one is accidently removed. The Canvas support desk cannot recover them either; they can only recover entire discussion topics, not individual postings. I would like to see both a warning message with a confirm delete message and a recovery option for either (or both) Students and Instructors.

jdmsc88 · ‎11-05-2020

Hi I am very new to using Power BI, I am keen to build some LMS analytics in Power BI. Would anyone be kind to sample templates or direct me to where I can find some to work with? Many thanks.

jpoulos · ‎09-30-2022

Please review whether your integrations will be affected by this change.

MikeBrinkman · ‎09-15-2022

I created a chart report that shows our numbers of published & unpublished courses year over year. One thing I'd like to exclude is courses with 0 enrollments. These courses would never be published, so it skews the results. I created a new column in my course_dim table called student_enrollment, then I wrote a DAX statement for that column: student_enrollment = calculate(countrows(enrollment_dim), filter(enrollment_dim, enrollment_dim[type] == "StudentEnrollment" && course_dim[id] == enrollment_dim[course_id] && enrollment_dim[workflow_state] <> "deleted")) The courses with 0 enrollment are blank instead of showing a 0, which doesn't seem like it should be a problem. When I add the student_enrollment column as a filter to my report, I select "Show items when the value is not blank", then click Apply filter, nothing changes. If I change it to "is blank", all the results disappear. Any ideas?

Community

Have a Canvas Question?

Have a Mastery Question?

Have an Elevate Question?

Have an Impact Question?

Canvas Data Users

Group Hub Activity

quiz_submission_historical_dim does not contain historical dates

Deleted Discussion Posts

Power BI LMS Templates

Certain table's columns were incorrect, and will now contain correct IDs

PowerBI DAX & Chart Question