What are filters, groupings and collations?

When setting up a custom report through School > Custom Report Writer, you can apply filters (step 6), groupings (step 7) and collations (step 8) to ensure your report only contains the information you need and in the right format.

  • Filter - Applying a filter reduces down the data output in your report to only what you want to look at.
  • Group - Grouping your report will give you an average calculation for each group's data and the size of each group.
  • Collate - Collating your report will put all results of a similar type together.

Let's take a look at an example report, and apply a filter, grouping and collation, in turn, to show you what each thing does to the report.

Here is my default report, reporting on the students' names, registration form and roll call attendance. Right now, it is showing all students that have been enrolled in my school this year.




First, we'll look at what happens when you add a filter. I'm adding a filter for Roll Call attendance to be equal to 100%.




My report will then only show students who have Roll Call attendance of 100%.




Next, let's look at what happens when you add a grouping. Please note, for this example, I have removed the filter so my report included all students, but you can add both a filter and group your report at the same time.

I'm going to add a grouping for Year Group. 



My report will then show the average attendance for each year group, and how many students are in each year group.




Finally, we'll look at what happens when you add a collation. Please note that you can't add a collation to a report that is already grouped.

I'm going to add a collation for Registration Form. 



My report will then show all students, but they will be sorted based on their registration form.



If you download the report, each registration form will be put into a different tab.


Was this article helpful?
0 out of 0 found this helpful
I'm still stuck!



Please sign in to leave a comment.