Week-on-week weekly attendance percentage report

This article explains how to create a week-on-week attendance percentage report for students using the Custom Report Writer. It details the steps to add attendance data for each week of the academic year and how to customise the report by grouping data, with a note on the need to manually add columns weekly. If you instead want to run an attendance report of just the past week, you can use our Weekly Attendance Report by Year Template.

Screenshot_2022-08-24_at_16.22.16.png

Screenshot_2022-08-24_at_16.22.39.png

 

Follow our guidance for Creating a report in Custom Report Writer to create a new report about Students.

Screenshot_2021-11-22_at_13.00.18.png

 

When you get to the Columns step, add the Statutory/Roll Call Attendance (Present) field to the right-hand column.

Screenshot_2021-11-22_at_13.00.49.png

 

In the slide over, select a Custom date range and set it to the first week of term.

Repeat this for each week of the academic year so far. Once you've added them all, you can click Skip setup wizard.

Screenshot_2021-11-22_at_13.01.24.png

 

Add in any groupings you need, for example, if you want to view the attendance broken down into year groups rather than for individual students.

Screenshot_2021-11-22_at_13.03.18.png

 

Then click to view your report - you can then share it or download it.

Screenshot_2022-08-24_at_16.22.16.png

Screenshot_2022-08-24_at_16.22.39.png

 

Please note that each week, you will need to add a new column as we cannot do this automatically.

Screenshot_2021-11-22_at_14.25.29.png

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

Comments

0 comments

Article is closed for comments.