Filtering Indicators, Multiple Expressions, Dates, Percentages, Yes/No
When , as shown in the following example, filter on the color: Red, Yellow, Green, or Gray.
To into one filter, select an and or or operator from the drop-down list at the end of the row.
When , refer to the following table 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 .
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 , 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 values, enter or for the values.
Click to regenerate the report with the filter applied.
The report will now contain a 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
- Generate a tabular report, such as the Job Summary or the VM Summary report.
- Click Actions and select Filter.
- Click the Columns tab. By default, all columns are checked.
- Uncheck the columns to remove from the report.
- 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.
