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.
1. Generate a tabular report, such as the Job Summary or the VM Summary report.
2. Click
Actions and select
Filter.
3. Select a field name in the first drop down list.
5. Enter a value in the third drop down list.
6. Select And/Or if you are adding another set of filters to your query.
7. Click Add Filter to add up to 12 additional filters.
8. 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. See
Customizing Report Filter Logic.
Customizing Report Filter Logic
Customize filter expression order and the operators using the Filter Logic field. Logic defined in this field will override any setting established on the top of the dialog. Use the numbers on the left of the filter expressions to construct your Filter Logic.
1. Click
Show Filter Logic to expand the window. This action disables the operators you set, and the Filter Logic field becomes mandatory.
2. Edit the logic using the filter numbers and by adding parentheses or changing the operators. For example, you can change “1 AND 2 OR 3” to “1 AND (2 OR 3)”.
Report Filter Operators
Operator | Description |
equals1 | Filters rows where the value of the associated column is equal to the value entered. The column can be of the type Number, Date or String. |
not equal1 | Filters rows where the value of the associated column is not equal to the value entered. The column can be of the type Number, Date or String. |
greater than | Filters rows where the value of the associated column is greater to the value entered. The column can be of the type Number, String, Date, Duration, and File Size. The match is case insensitive. |
less than | Filters rows where the value of the associated column is smaller than the value entered. The column can be of the type Number, String, Date, Duration, and File Size. The match is case insensitive. |
greater than or equal to | Filters rows where the value of the associated column is greater than or equal to the value entered. The column can be of the type Number, String, Date, Duration, and File Size. The match is case insensitive. |
less than or equal to | Filters rows where the value of the associated column is smaller than or equal to the value entered. The column can be of the type Number, String, Date, Duration, and File Size. The match is case insensitive. |
contains1 | Filters rows where the value entered is present anywhere in the value of the associated column. Example: If the column value is “rattle” and the value entered is “rat” or “at” the row will be displayed. The column can only be of the type String. |
does not contain1 | Filters rows where the value entered is not present anywhere in the value of the associated column. The column only can be of the type String. |
is a member of | Filters rows where the value of the associated column is equal to any of the comma-separated values entered. There is no limit to the number of characters that can be entered for this value. The column can be of the type Number, String, Duration, and File Size. Example: If you enter a value of chair, table, desk and the column value is table, the row will be displayed. |
is not a member of | Filters rows where the value of the associated column is not equal to any of the comma-separated values entered. There is no limit to the number of characters that can be entered for this value. The column can be of the type Number, String, Duration, and File Size. |
matches regular expression | Filters rows where the value of associated column matches the regular expression2 entered. The column can only be of the type String. For example, to find a column starting with S, use ^S or ^[Ss] |
does not match regular expression | Filters rows where the value of associated column does not match the regular expression2 entered. The column can only be of the type String. |
Table 1
Filtering Indicators, Multiple Expressions, Dates, Percentages, Yes/No
• When filtering on Indicator Lights, as shown in the following example, filter on the color: Red, Yellow, Green, or Gray.
• To combine several expressions into one filter, select an and or or operator from the drop-down list at the end of the row.
• When
filtering on dates, refer to
Table 1 to determine which columns can be filtered on date. Be aware that filtering on Dates needs to be carefully designed in order to avoid degradation of performance. Date criteria can be specified in the following formats:
mm/dd/yyyy | Specified date |
Now | Current date and time |
Today | Current day |
+nd -nd | Enables a variable time frame (plus or minus a number of days) For example: +2d This criteria can be combined with Today. For example: Today-5d |
+nh -nh | This hour option enables a selection of a date and time, plus or minus a number of hours from the current time. For example, in the Job Summary Report, select all jobs where the Finish Time was greater than -12h. This would isolate jobs for only the last 12 hours. |
• When filtering on percentages, such as in the NetApp Volume Summary Report, enter a decimal value equivalent to the percentage.
ex. | 100% - 1.0 75% - .75 50% - .50 25% -.25 10% - 0.1 |
• When filtering on Yes/No values, enter Y or N for the values.
• Click OK to regenerate the report with the filter applied.
The report will now contain a filter applied link, enabling access to the defined filter. When you save this report, the filter is saved with it.
To filter reports by columns
Note: Reports can have both row and column filters applied.
The following tabular reports do not support column filtering:
• Billing and Chargeback Summary
• Chargeback by Host
• Array Performance by RAID Group
• Port Throughput by Array
• Datastore Performance Summary
1. Generate a tabular report, such as the Job Summary or the VM Summary report.
2. Click
Actions and select
Filter.
3. Click the Columns tab. By default, all columns are checked.
4. Uncheck the columns to remove from the report.
5. Click OK to regenerate the report with the filter applied.
The report will now contain a filter applied link, enabling access to the defined filter. When you save this report, the filter is saved with it.
