Setting up a field in a PCR Educator DAT Query is one choice. The Fields step gives each field a single Role: Group, Aggregate, or Pivot. Choose the role, and the controls that role needs appear with it.
What's new
One Role per field. Each field in a DAT Query has a single Role with three values: Group, Aggregate, and Pivot. The role drives how the field behaves in the query.
Controls that match the role. Choosing a role brings up the controls it needs. The Aggregate role brings the function and Partition By options. The Group role keeps the row simple.
Pivot offered where it fits. The Pivot role appears for fields that are eligible to be pivoted.
Why it matters
One decision sets up a field. The field grid stays focused on what each row actually uses, so a DAT Query is quick to build and quick to read, especially for someone building their first one.
A few ways to talk about it
- Field setup in a DAT Query is one Role choice per field: Group, Aggregate, or Pivot.
- Each role brings its own controls, so the grid shows what the field actually uses.
- Quick to learn on a first DAT Query, quick to scan on every one after.
Available now to all PCR Educator schools. Your account team can walk you through the Role column whenever you're ready.