A PCR Educator DAT Query can now compute an aggregate across a wider group than the row it sits on, while the query stays grouped at its own level. A new Partition By option on any Aggregate field puts a row's own number and the total it belongs to side by side. Running totals, subtotals, and share-of-whole calculations fit in a single DAT Query.
What's new
Partition By on any Aggregate field. Set a field's role to Aggregate, choose the function (Sum, Count, Average, and the rest), then pick a Partition By column from a typeahead. The aggregate computes across that wider partition while each row stays grouped at the DAT Query's own level.
Optional on every Aggregate field. Partition By is there when you want a wider calculation. An Aggregate field with no partition set is a standard aggregate.
One DAT Query for the comparison. A row can show its own value and the value of the group it belongs to, together, in a single DAT Query.
Why it matters
A row can carry both its own number and the number it belongs to. Show each course's enrollment next to its department's total enrollment. Show a donor's giving next to the campaign total. Show a student's tardies this term next to their full-year count. The reader sees the part and the whole together, and the comparison is immediate.
Available now to all PCR Educator schools. Your account team can walk you through Partition By in a DAT Query whenever you're ready.