*
Concepts
*
Tasks
*
Settings

Changing the Order of Filtering Criteria

If you have multiple criteria in one filter group, the order in which you arrange the filtering criteria also affects the results. When there are three or more filtering criteria, APM uses the order of operations rules to determine the order in which to evaluate them. Criteria from the same filter group are evaluated together, with criteria that are connected with the AND operator evaluated before OR operators.
Changing the evaluation sequence can alter the results of the search. For this reason, each filtering criterion has a sequence number. Because you can have different relationships between the criteria within a group, be sure to arrange the criteria in the correct sequence. However, in spite of the sequence number, ANDed criteria are always evaluated first (as though they were bracketed). For example:
1. A = 3
2. or A = 7
3. or A > 11
4. and A < 21
will be evaluated as A=3 or A=7 or (A>11 and A<21).
If you add more criteria for a different attribute, these will be ANDed to the previous group. Each filter group would be evaluated as a unit. For example:
(A=3 or A=7 or (A>11 and A<21)) and (B=1 or B=2)

To Change the Sequence Number of a Filtering Criterion

1.
Open the indicator that uses filtering criteria in its calculation.
2.
Make sure that editing is enabled.
3.
Select the Calculation tab.
4.
In the Inputs table, double-click the filter-based calculation input that you want to edit. The Calculation Input dialog appears.
5.
On the General tab, review criteria listed in the Selection criteria table.
6.
Select the criteria that you want to move and press F2. The criteria becomes open for editing in the table. Press the Tab key until the cursor is in the Seq column.
7.
Enter the new sequence number and press Enter.
8.
Repeat steps 6 to 7 until all of the criteria have the correct sequence.
9.
When you are finished, click OK to close the Calculation Input dialog.
10.
If necessary, repeat steps 4 to 9 to edit another calculation input.
11.
When you are finished, save and close the indicator.