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.