Table Column Filtering

Instead of using a Filter Box, you can right-click on a table column header and select Filter to perform filtering.

 

 

The dialog box that displays will depend on the data column type.

q  For numeric columns:

 

Enter the numeric range filter then click either:

·        Include to include the entered range, or

·        Exclude to exclude the entered range.

q  For text columns:

This text entry box is the same as the filter in Include/Exclude mode.

 

q  For time columns:

 

Enter the time range filter then click either:

·        Include to include the entered range, or

·        Exclude to exclude the entered range.

When a filter is applied on the table columns, filter icons appear at these places:

q  To the right of the table column header

q  Table Header Control

q  Dashboard toolbar

q  Table Column Filter dialog

Clicking will remove the filter.

Also, Show Active Filters   icon displays on the Table Header Control. This allows viewing of all the active filters on the dashboard and its visualizations.