Posted September 16, 2026
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.
Show sets whether the field appears as a column in the results. Every field row starts with Show selected. Clear Show to keep the field in the query and leave its column out of the results, the Export file and dashboards. A field with Show cleared keeps working in the query: calculated fields can use it, and a Group field with Show cleared still splits rows by its values, so two rows can look the same when only that hidden field differs. Print, Print to PDF and DataSource still include the field, so mail merge templates can use it. On DAT Column Order - Step 3, the field is listed in gray with "(hidden)" after its name.
Example: A calculated field named Full Name is built as [First Name] + ' ' + [Last Name]. Clear Show on First Name and Last Name so the results show only Full Name.
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.