This Tableau workbook provides a report that details the status of quiz availability dates within courses. This is primarily used to confirm settings for midterm and final exams prior to the term start. If the availability date is specified, the report shows that date under 'Unlock At (Quiz Dim)'. Otherwise, this column shows 'null'. Included in the report is a red x mark for when there is no 'available from' date set and a hyperlink that points to the quiz page.
Midterm or Final
|IF CONTAINS([Title (Assignment Dim)],"Final")then "Final"|
ELSEIF CONTAINS([Title (Assignment Dim)],"Midterm")then "Midterm"
ELSEIF CONTAINS([Title (Assignment Dim)],"Mid-term")then "Midterm"
else "" END
Quiz Date Set?
|IIF(ISNULL([Unlock At (Quiz Dim)]), 'Date Not Set', 'Date Set')|
|'https:// xyz.instructure.com/courses/'+ STR([Canvas Id (Course Dim)]) + '/assignments/' + STR([Canvas Id (Assignment Dim)])|
|IF [Crse No.] < '500' then "UG"|
Data source tables and filters: