Select Fields

Use this screen to select the fields upon which to base your query. You may select fields from different tables in your data service (note that you must select fields from at least two different tables to use joins). There is no limit to the number of fields you may select.

Selecting fields typically determines which fields will be displayed in the result. For the Count (relational) template, the order in which you select the fields is also important because it determines grouping (see Example, below).

When using the Heatmap template, at least two of the fields you select must be numeric.

Structure

The main sections and controls of this screen are listed in the following table:

Section	Control	Description
	→ button	From the Available Tables and Fields list, transfers a selected field, or all fields in a selected table, to the Selected Values list.
	← button	Removes a selected field from the Selected Values list.
	Clear button	Removes all fields from the Selected Values list.
Available Tables and Fields		Lets you look for a table or browse the tables catalog. See Find Data Services Task Panel for a description of the similar Look for functionality. The data service tree lists the system you selected on the Select a System screen as the root node in the tree, followed by any catalogs contained in that service, followed by any schema contained in the catalog, followed by any tables in the schema. Select individual fields or tables.
Selected Values		Lists the fields selected in the query, including their Table, Column, and Type identifiers.

Example

You are using the Count (relational) template to determine how many employees each manager is responsible for, and how many are part-time or full-time employees. To find out, you use the Count template and select the Manager field, and then the Type field from the Employees table. This query counts all occurrences in groups, with one group per selected field.

The result of such a Count query is a table such as the below:

Count Query With Grouping: Configuration One
Manager	Type	Count
Miller	Full-time	38
Miller	Part-time	3
Jackson	Full-time	10
Jackson	Part-time	1
Sullivan	Full-time	16

Note that the order in which the fields appear in the Selected Fields list is important. The results are first grouped by the first field, then by the second field, and so on.

If you had first selected Type and then Manager from the Employees table, the order of the columns above would be reversed, grouping the result first by employment type, then by manager, as in the table below:

Count Query With Grouping: Configuration Two
Type	Manager	Count
Full-time	Miller	38
Full-time	Jackson	10
Full-time	Sullivan	16
Part-time	Miller	3
Part-time	Jackson	1