Advanced Filtering for Tabular Reports
In addition to the filtering in the scope selector, table-formatted reports can be further filtered on Rows and/or Columns, using the following procedures.
Note:
To optimize performance, be sure to use the filtering that's available in the scope selector before using any advanced filtering.
To filter reports by rows
You can define the criteria for the data rows displayed in a report. Drop-down lists enable selections from the available columns. Next, you supply the operator--such as equals or does not contain--and a value for that column. Up to 16 selections can be joined to form the filter.
Filtering Limitations: Filtering on exact decimal values may produce inconsistent results, as reports display rounded values of higher-precision data. For example, a filter of MBytes equals 150.95 will return rows with rounded values. To configure a filter that more precisely narrows the content, include additional row-filtering criteria with > and < logic to limit the data that is displayed.
Note:
Reports can have both row and column filters applied.
- Generate a tabular report, such as the Job Summary or the VM Summary report.
- Click Actions and select Filter.
- Select a field name in the first drop down list.
- Choose an operator.
- Enter a value in the third drop down list.
- Select And/Or if you are adding another set of filters to your query.
- Click Add Filter to add up to 12 additional filters.
- Click Show Filter Logic to customize the filter logic if required. Logic defined in this field will override any setting established on the top of the dialog.
