The operating system
for modern schools.

A PCR Educator DAT Query now supports an Auto mode for the Pivot role. Pick a field, set its role to Pivot (Auto), choose the aggregate function and the field to count or sum, and the query discovers the most-frequent values on its own. Each becomes its own column, with an "Other" bucket catching everything else.

What's new

Pivot (Auto) as a field role. A new value in the Role dropdown sits next to Group, Aggregate, and Pivot. Pivot (Auto) is eligible for any field that holds categorical values, no upfront value list required.

Top values discovered at query time. The query finds the most-frequent values in the chosen field each time it runs, up to twenty columns, and adds an "Other" bucket for the long tail.

One aggregate per pivoted column. Count, Sum, Average, Minimum, or Maximum. Whatever function you pick applies to every discovered column and to "Other."

Built for fields where the value list is unknown or shifts. Course names, action types, donor categories, inquiry sources. Anywhere a manual Pivot would mean typing out values that change year to year.

Saves and reruns like any other DAT Query. The auto-pivot refreshes with the query, so the columns reflect the current data each time the report runs.

Why it matters

Manual Pivot expects the user to list the values that should become columns. That works when the list is short and stable. It does not work when the catalog changes from year to year, or when no one wants to track down every value a field can hold. Pivot (Auto) removes that work. A course-load matrix or an action-type breakdown stays current as new courses are added and new action types appear, with no edits to the query.

A few ways to talk about it

• Pick the field, the function, and the target. The columns come from the data.
• Top twenty values plus an "Other" bucket, refreshed every time the query runs.
• A natural fit for high-cardinality fields where the value list is unknown or shifts year to year.

Available now to all PCR Educator schools. Your account team can walk you through Pivot (Auto) in a DAT Query whenever you're ready.

A PCR Educator DAT Query now puts a copy icon on every field row. One click creates a second instance of the same field, and that copy carries its own role and settings. The same field can do two jobs in one DAT Query.

What's new

Copy icon on every row. Each field row in a DAT Query has a copy icon. Selecting it adds a second row for the same field, ready to configure on its own.

A role for each copy. The duplicate is a separate row with its own Role, so the same field can be grouped on in one row and aggregated on in another.

Two aggregates of one field. A number can appear as both a Sum and an Average in the same DAT Query, each in its own row.

Why it matters

A DAT Query often calls for the same field in more than one role. A date can group the rows and count them. A balance can show as a total and as an average in the same view. Duplicating a row makes both uses visible on screen: two rows, one field, each with its own job.

A few ways to talk about it

• A copy icon on every field row puts the same field to work in two roles.
• Group on a field and aggregate on it in the same DAT Query.
• Show a value as both a Sum and an Average, side by side.

Available now to all PCR Educator schools. Your account team can walk you through the duplicate-row button whenever you're ready.

A calculated field in a PCR Educator DAT Query can now reference another field by its alias name in square brackets, for example [Absences in Class] * 100.0 / [Total Absences]. The expression reads in plain English, and the DAT Query stays correct when fields move.

What's new

Reference by name. A calculated field can name the field it needs by its alias, written in square brackets. The alias is the field name you already see in the query.

Stable when fields move. An alias reference points to a field by name, so reordering or duplicating fields keeps every calculation correct. PCR Educator resolves the alias to the field when the DAT Query runs.

Readable expressions. An expression like [Gifts This Year] minus [Gifts Last Year] explains itself. The next person who opens the DAT Query can read the math directly.

Why it matters

Naming the field keeps the meaning of a calculation visible on the page. An expression built from aliases reads the way a school talks about its data. Concentration ratios, year-over-year deltas, and weighted averages can be written with names that say what they mean, and the DAT Query keeps working when someone rearranges the fields later.

A few ways to talk about it

• Calculated fields in a DAT Query reference other fields by name, so the math reads in plain English.
• Reorder or duplicate fields freely. Alias references stay pointed at the right field.
• Concentration ratios, year-over-year deltas, and weighted averages, written the way you would say them.

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