Missing Assignments indicates the number of assignments that have missing submission status in Canvas.
| Metadata |
|---|
| Where Term Appears |
|---|
| CSUMB Data Warehouse Dashboards: |
|
|---|
| Other Reports: | N/A |
|---|
|
| 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 |
| OBIEE Folder and Column |
|---|
| Folder Heading: | "Dim - LMS - Detail Assignment" |
|---|
| Column Heading: | "Status" |
|---|
|
|