Skip to content
Rambling Pete's Quick examples
First of all, thank you for ranking effort and not achievement A row (student and task) is only created when the task is handed in. 1
rbCompleted Tasks per student
There are no rows in this table
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 (