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.

A few ways to talk about it

• Running totals, subtotals, and share-of-whole math live in a single DAT Query.
• Partition By sets each row next to the total of the group it belongs to.
• An Aggregate field with no partition set stays a standard aggregate.

Available now to all PCR Educator schools. Your account team can walk you through Partition By in a DAT Query whenever you're ready.