PCR Educator filters now support count, sum, and average conditions, the same aggregate logic that has long lived inside DAT queries. Schools can build saved filters that find students based on how many records they have or how much something totals, then drop those filters into notification triggers, contracts, or anywhere else a saved filter is used.

What you can build

Aggregate filters answer the questions schools ask every day:

• Students with more than 8 absences this semester
• Students with more than 4 discipline points in the current marking period
• Students with at least 3 tardies in any marking period
• Students who have any record in a given table

Build the filter once. Reuse it everywhere a saved filter is selected.

Key capabilities

Six aggregate functions. Sum, Count, Count Distinct, Average, Min, and Max are available across supported fields.

Time-window scoping. Combine aggregate conditions with marking period, semester, academic year, admissions year, fiscal year, or development year, so counts stay inside the window that actually matters.

Round-trip editing. Save an aggregate filter, reopen it, and the condition reads cleanly (for example, "Count of records > 4").

Plain-English filter descriptions. Saved aggregate filters describe themselves in the filter list and pickers, so the next person who picks one up understands what it does at a glance.

Why it matters

A request like "find students with more than 4 discipline points in the current marking period" used to require a custom DAT report or a one-off query. Now it is a single saved filter that any teacher, advisor, or admin can reuse, drop into a notification trigger, or attach to a contract. Logic that lived only in the reporting layer is now usable across the system, in the same place schools already manage their saved filters.

A few ways to talk about it

• Filters now ask aggregate questions: count, sum, average, min, max, count distinct.
• Save once, reuse everywhere: notification triggers, contracts, and any picker that takes a saved filter.
• Time-aware counts: scope to marking period, semester, academic year, admissions year, fiscal year, or development year, so the math matches the calendar.

Available now to all PCR Educator schools. Your account team can walk through example filters whenever you're ready.