Missing Assignments indicates the number of assignments that have missing submission status in Canvas.
| Metadata |
|---|
| Data Custodian |
|---|
| Center for Academic Technologies |
| Data Source |
|---|
| Source System: | LMS - Canvas |
|---|
| Source Table Name: | WC_LMS_DTL_ASSIGN_D (Built using ASSIGNMENT_DIM,ASSIGNMENT_OVERRIDE_DIM etc) |
|---|
| Source Field Name: | SUB_WORKFLOW_STATE,STATUS |
|---|
| Census Process: | N/A |
|---|
|
| Logical Transformation / Calculation |
|---|
| SUM(CASE WHEN sub_workflow_state <> 'graded' and status = 'Missing' THEN 1 ELSE 0 END) as assgn_missing
from WC_LMS_DTL_ASSIGN_D |
| Dataset Folder and Field Name |
|---|
| Dataset Folder: | "Dim - LMS - Detail Assignment" |
|---|
| Field Name: | "Status" |
|---|
|
|