Week on Week Comparisons

Working for a multi academy trust I was asked to provide comparison of a range of measures (attendance and suspensions) by week with the same week the previous year. On the face of it this sounds simple until you realise that each academy has slightly different term dates and within that use inset days differently […]

Read More Week on Week Comparisons

Calculation Groups and RLS

I had a specific requirement to be able to show summary data for a whole organisation ignoring any RLS while being able to slice by all attributes. At the same time I needed to only show data attributed to names, for particular groups defined by RLS. There are many approaches to doing this. One I’d […]

Read More Calculation Groups and RLS