Day 19 - Instructor Dashboard(Part 1)

Instructor Dashboard shows grade and assignment states

Create 4 Alias table in Incorta

Instructor_Enrollment

Student_Enrollment

User_Instructor

User_Student

Table join

In enrollment, table add 2 formula columns

int(
 if(
 canvas.enrollments.type = 'TeacherEnrollment', 
 canvas.enrollments.user_id, 
 -1
 )
)
int(
 if(
 canvas.enrollments.type = 'StudentEnrollment', 
 canvas.enrollments.user_id, 
 -1
 )
)