1. Using Oracle Fusion Analytics Warehouse
  2. Work with Projects
  3. Create and Apply Filters
  4. About Filters and Filter Types

About Filters and Filter Types

Filters reduce the amount of data shown in visualizations, canvases, and workbooks.

The Range, List, Date, and Expression filter types are specific to either a visualization, canvas, or workbook. Filter types are automatically determined based on the data elements you choose as filters, but you can also switch to select another compatible filter type.

  • Date filters - Use calendar controls to adjust time or date selections. 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. See Apply Date Range Filters.

  • Expression filters - Let you define more complex filters using SQL expressions. See Apply Expression Filters.

  • List filters - Applied to data elements that are text data types, number data types that aren’t aggregatable, and date data types. List filters are applied to the whole canvas or to a specific visualization on the canvas. See Apply List Filters.

  • On-canvas filters - Applied to attribute data elements. This filter type is added to and displays on the canvas and allows users to choose how to filter visualizations on the canvas. S.

  • Range filters - 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). See Apply Range Filters.

  • Top and bottom filters - Applied to measure and attribute data elements. You can specify whether to filter by top or bottom, specify the number of items to display, and which measure or attribute to limit by. See Apply Top Bottom N Filters.