Working with filters
To use filter options
In the Categories field, select a category.
The Metrics field displays all the selected metrics from the current category. You can add or delete metrics from this list.
For more information about adding categories, see Working-with-reporting-categories.Selecting the Show Advanced Metrics option in the Metrics field displays the advanced metrics in the list.
The filter selections work from left to right. Changing an object in a filter invalidates all filter selections that are on the right.- (Optional) Use the Search field to restrict the displayed filters.
You can use wildcard characters. For more information, see To use filter values and wildcard characters in the search field.
To get the complete list of the filter values, clear all text in the Search field. - (Optional) Select the Aggregate Selections check box to aggregate all selections in a filter to a single object and produce a single series on the chart.
When you select the Aggregate Selections check box for a given filter, aicon indicates that the selections for that filter item are aggregated.
Click Run Query or Run Query with Alerts.
The Run Query with Alerts check box is displayed only if you have selected a category that has attached alerts.- If you select Run Query, the query runs only for the category selected in the filter bar. If there are multiple categories and you have made changes to any of them, click Run Query for each modified category.
If you select Run Query with Alerts, the alert processing occurs only for the selected category. If alerts are generated, the Alert Preview window displays the alert information.
For more information about attaching alert rules, see Managing-alerts.The current report view displays the data.
To use filter values and wildcard characters in the search field
In the filter bar, when you use the filter values and wildcard characters in the search field, the following conditions apply:
Filter values/Wildcard | Result | Example |
---|---|---|
Any value | Exact match | Entering CM returns CM only, but not CM01, CM123, and so on. |
"*" | Matches any number of characters starting from 0 | Entering "CM*" returns a match of CM, CM01, CM123, and so on. |
? | Matches exactly one character in the value entered | Entering CM?2 returns a match of CM12, CM22, CM32, and so on. |
(Prefix) ! | Matches all the strings that do not match values using this prefix. | Entering !CM returns a match of all values except CM. Entering !CM* returns a match of all values except CM, CM01, CM123, and so on. Entering !CM?2 returns a match of all values except CM12, CM22, CM32, and so on. |