A list filter can be applied to data elements that are text and date data types, and number data types that can't be aggregated. A list filter provides a simple list of values to choose from and lets you see which values are selected and which aren't. They work well for attributes with a long list of values.

Availability: List filters are available for all filter scopes.

Limitations: While list filters don’t have a limit to the number of values they can display, performance can decline if more than 10,000 values are selected.

A list box filter is similar to a list filter and can be applied to text, uncountable values, and dates. It also provides a simple list of values but only lets you select one or All.

Availability: List box filters are available only for dashboard filters.

A checkbox or radio button filter can be applied to text, uncountable values, and dates. When Multi Select is on, the filter uses a checkbox, and when it's off, the filter uses a radio button.

Availability: Checkbox or radio button filters are available only for dashboard filters.

A top bottom N filter can be applied to measure and attribute data elements. For example, you might filter a visualization by the top 10 customers based on sales.

Availability: Top bottom N filters are available for all filter scopes.

A range filter can be generated for data elements that are number data types and that have an aggregation rule set to something other than none. Range filters are applied to data elements that are measures, and that limit data to a range of contiguous values, such as revenue of $100,000 to $500,000. Or you can create a range filter that excludes (as opposed to includes) a contiguous range of values. Such exclusive filters limit data to noncontiguous ranges (for example, revenue less than $100,000 or greater than $500,000).

Availability: Range filters are available for all filter scopes.

Properties:

• Start - Specifies the minimum value.
• End - Specifies the maximum value.
• By - Specifies which measure or attribute to limit by.

A date range filter uses calendar controls to adjust time or date selections to limit data to a specific period of time. You can either select a single contiguous range of dates, or you can use a date range filter to exclude dates within the specified range.

Availability: Date range filters are available for all filter scopes.

Properties:

• Range - Requires a start and end date to filter on.
• Start at - Requires only a start date to filter from.
• End at - Requires only an end date to filter to.
• Equal - Requires a specific date to filter on.

A relative time filter focuses on values for a specified time period relative to today or end of last period. For example, you can focus on the last three years, the next three years, or year to date through the last fiscal period.

The current date and time used in queries is the Oracle Analytics server host's date and time in the server's timezone (not the browser host's time or timezone).

Availability: Relative time filters are available for all filter scopes.

Limitations: You can apply a relative time filter only to date columns that already exist in the data source, not to derived columns such as Year, or Quarter. The relative time filter type supports Date and DateTime column types.

A slider filter can be used to animate visualizations and show dynamically how your data changes over a given dimension such as time. A slider filter can be applied to text, uncountable values, and dates.

Availability: Slider filters are only available for dashboard filters. See Filter and Animate Visualizations using a Slider Dashboard Filter.

Your administrator sets the Oracle Analytics Default Limit Values By for Filters system setting.

This is the highest-level limit values setting and is applied to all workbooks. You can override this setting at various levels within a workbook.

The option chosen by the administrator is used as the default setting in the workbook filter bar.

The workbook filter bar inherits the system setting by default but you can use the Limit Values By setting for the filter bar to override the system setting.

The setting you specify in the workbook filter bar is applied to all filters and selection steps in the filter bar.

See Specify Limit Values By for the Workbook Filter Bar.

Any filters and selection steps that you add to the filter bar inherit the Limit Values By setting selected for the filter bar.

You can select an individual filter or selection step and use Limit Values to override the filter bar's setting for that particular item.

This setting level isn't available for individual parameters used in the filter bar.

See Specify Limit Values for Workbook and Canvas Filters and Selection Steps.

Dashboard filters are limited by the workbook or canvas filter selections depending on the Limit Values By setting on the filter bar and the Limit Values setting on the individual workbook or canvas filters.

You can select an individual dashboard filter and use Limit Values to override the workbook or canvas filters' or workbook filter bar's setting.

This setting level isn't available for parameters used as dashboard filters.

See Specify Limit Values for Dashboard Filters.

Visualization filters

Visualizations display data according to the limitations you set for any existing workbook, canvas, and dashboard filters. If you add a visualization filter for the same column as a dashboard filter or a filter in the filter bar, the visualization filter is limited by the filter selections for that dashboard filter or filter in the filter bar.

For the filter bar, uses the Default Limit Values By for Filters system setting that your administrator set.

For individual workbook or canvas filters in the filter bar, uses the Limit Values By setting from the filter bar.

Doesn't apply to selection steps.

For dashboard filters, uses the Limit Values By setting from the filter bar. Or if the canvas contains a workbook or canvas filter and a dashboard filter that use the same column, the default uses the Limit Values setting for the workbook or canvas filter.

This option is enabled by default for workbook, canvas, and dashboard filters.

For both the filter bar and individual workbook or canvas filters in the filter bar, limits the filter selection values by the other filter selections in the filter bar.

Doesn't apply to selection steps.

For dashboard filters, limits the filter selection values by the other dashboard filter and workbook or canvas filter selections.

For both the filter bar and for individual filters and selection steps in the filter bar, doesn't limit the selection values by the other selections in the filter bar.

For dashboard filters, doesn't limit filter selection values by the other dashboard filter and filter bar selections.

For individual filters and selection steps in the filter bar, uses the selected selection step, workbook, canvas, or dashboard filter's selections to limit selection values.

For dashboard filters, uses the selected selection step, workbook, canvas, or other dashboard filter's selections to limit selection values.

You can choose more than one.