Minimum/Maximum Parameters

Use the Configure Minimum/Maximum Parameters screen to configure parameters specific to the Minimum/Maximum template. With this template, you can build queries that find the minimum or maximum value of a field and provide details from the row that holds that value.

This template can address business questions such as the following:

Which store has the smallest revenue; where is that store and who is the manager?

Structure

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

Section	Control	Description
Select criteria	Smallest	Indicates that the value should be the smallest (minimum).
Largest	Indicates that the value should be the largest (maximum).
Select field	Lists all fields in any table selected on the Select Fields screen. Select the field in which to search for the smallest or largest value. Although the fields you selected with Select Fields determine which fields will appear in the result, you can base your minimum or maximum requirement on any field in the table. The field you select does not have to be a numeric data type.

Section

Control

Description

Select criteria

Smallest

Indicates that the value should be the smallest (minimum).

Largest

Indicates that the value should be the largest (maximum).

Select field

Lists all fields in any table selected on the Select Fields screen.

Select the field in which to search for the smallest or largest value.

Although the fields you selected with Select Fields determine which fields will appear in the result, you can base your minimum or maximum requirement on any field in the table. The field you select does not have to be a numeric data type.

Example

You want to know which store has the smallest revenue, where the store is, and who the manager of the store is. To find this out, you configure the values on this screen in the following manner:

Since you want to see the store, city, and manager's name in the result, you have already used the Select Fields screen to select the Store, City, and Manager fields from a table called Sales.
On this screen, select the Smallest radio button.
From the Field drop-down list, select the Sales.Revenue field (the Revenue field from the Sales table).

The result of this query is one row displayed in a table such as the following:

Smallest Revenue: Store Details
Store	City	Manager
NotSoSuperStore	Palo Alto	Jones

The result shows that NotSoSuperStore had the smallest revenue, and the fields (columns) displayed in the table are those that you configured on the Select Fields screen. Note that you do not actually need to see the Revenue field in the result, since you know the query result will show you the record with the minimum value for Revenue.