Dell PowerConnect W Clearpass 100 Software 3.9 Deployment Guide - Page 344

To edit an output series field, click the Edit link for the field. The Edit Series field opens, as shown below. The Header is displayed in tables and charts that use this output series. Use a short description of the values contained in this field. The Value Format specifies how to generate the value for the output series field. You can specify an expression to calculate the value; in the expression, use the variable $_ to obtain the value of the report field for this output series. In most cases it is not necessary to perform data formatting for the fields in the output series, as this is normally achieved in the report's presentation blocks. Use a value expression only if the actual value to be displayed should be modified (for example, converting from bytes to megabytes), or if the underlying format of the value should be changed (for example, converting from a bin number to a date). Select the Do not show this series field on charts check box to prevent the display of the series field on charts. This option is useful if the same output series is used in two presentation blocks, one being a chart showing summary data and the other being a table showing detailed statistics. Output Filters Output filters are applied to the output series defined in the report to determine whether a particular item will be included in the output of the report. The presentation blocks of the report can only include the output data that has passed through the output filters. You should define output filters to specify what parts of the output data you are interested in looking at. You can also define output filters to specify what output data should be excluded from the report. Output filters can filter on either unformatted source data or formatted output data. Unformatted source data is the data used to generate the output series; depending on the dimension of the output series, this may include either raw source data and derived fields or statistic and metric fields. Formatted output data is the actual content of the output series after any data processing has been applied in the output series definition. Use filtering based on unformatted source data to exclude output series items based on a certain data field, statistic or metric value in the data. Use filtering based on the formatted output series to exclude output data based on group or bin values, as these typically need to be formatted before they are of use. The output filters are ordered, which means the filters will always be applied in the same order to each item of the output series. You can reorder the filters to obtain precise control over exactly which data will be included in the report's output. Output filters are of three basic kinds:  Range filters check to see if a value falls within a certain range. 344 | Report Management ClearPass Guest 3.9 | Deployment Guide