Configuring Minimum/Maximum
Parameters 
Use
Use this screen to configure the parameters specific to the Minimum/Maximum template. See Minimum/Maximum (Relational) for the description, business question, and workflow for using this template.
Procedure
...
1. Select whether the value should be the Smallest (minimum) or Largest (maximum) value.
2. In the Field drop-down list, select the field in which to search for the smallest or largest value.
¡ All fields in any table selected on the Select Fields screen appear in the drop-down list. 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.
3. Click Next.
Result
You proceed to the Preview Result screen.
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:
This example assumes you have similar types of metadata available in your data service.
1. Select the Smallest radio button.
2. From the Field drop-down list, select the Sales.Revenue field (the Revenue field from the Sales table).
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 Store, City, and Manager from a table called Sales.
The result of this query is one row displayed in a table such as the following:
Minimum/Maximum Query Result
Store |
City |
Manager |
SuperStore |
Palo Alto |
Jones |
The result shows that SuperStore 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.