Add a Window Column to a Custom Report
This lesson will guide you through adding a Window Column to a Custom Report.
What is a Window Column?
A Window Column runs your report with all other columns first, then it walks through the results. It looks at the groups of records, and calculates a value for each group.
Think of it like this:
I want to calculate ______, by looking at ________, and sorting those values by _______, then I want to calculate and show this for each ________.
Many times this can be useful for things like: getting the most recent score from multiple attempts at an assessment, to get percentages of a total, or to get a sum to then filter by total transcript units.