99.987% uptime·0 security breaches·35+ years in education·Built and supported in the U.S.

Main2026

Posted May 19, 2026

DAT Fields - Step 2

DAT Fields - Step 2
The DAT Fields - Step 2 (DAT > Queries > Fields) is an optional step for creating a DAT Query. The DAT Fields - Step 2 step covers the following features:

- DAT Fields - Step 2 - Customizing Display Fields Appearance

- DAT Fields - Step 2 - Sorting

- DAT Fields - Step 2 - Aggregating

- DAT Fields - Step 2 - Pivoting

- DAT Fields - Step 2 - Uniqueness

- DAT Fields - Step 2 - Adding Calculated Field

- DAT Fields - Step 2 - Totaling

Path refers to the table for the field. Sometimes you might have the field appear multiple times and this path helps you distinguish which field is which.

Field is the name of the field being referenced.

Each field is a row in the field grid.

Role determines how the field behaves in the query. Each field row has a single Role with three values: Group, Aggregate, and Pivot. Selecting a Role shows only the controls that role needs. The Pivot role is offered only for fields that are eligible to be pivoted. See DAT Fields - Step 2 - Aggregating and DAT Fields - Step 2 - Pivoting.

To use the same field in more than one way, select the copy icon on its row. The copy icon adds a second row for the same field, and the duplicate carries its own Role and settings. For example, one field can be grouped on in one row and aggregated on in another row of the same query.