Ranking Board

Ranking board 1 - Most simple

First of all, thank you for ranking effort and not achievement
Assumptions
A row (student and task) is only created when the task is handed in.
rbStudents
0
rbTask list
0
rbCompleted Tasks per student
1
Search
Student
Task
Completed
Hide Completed count
1
Person 1
Task 1
1
2
Person 2
Task 1
2
3
Person 2
Task 2
2
4
Person 3
Task 1
1
There are no rows in this table
4
Count
Ranking Board
1
Search
Student
Hide Completed count
1
Person 2
2
2
Person 1
1
3
Person 3
1
No results from filter

Workings & notes
Formula used for “colAverage per topic” Column
[tabAverage Formula].Filter(colTopic=thisRow.colTopic).colNumber.Average()
English: In the tabAverage table, find all the rows that are the same topic as the topic of this row, and calculate the average for the selected rows.
[rbTasks per student].Filter(thisRow.Student=thisRow.Student).Student.Count()
[rbTasks per student].Filter(thisRow.Student=thisRow.Student).Student.Count()

Combine filter criteria using &&

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.