About Filters and Filter Types

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

The Range, List, Date, and Expression filter types are specific to either a visualization, canvas, or project. Filter types are automatically determined based on the data elements you choose as filters.

  • 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 data elements. You can specify whether it’s a top or a bottom filter, specify the number of rows to display, and which attributes to group by. See Apply Top Bottom N Filters.

  • List filters - Applied to data elements that are text data types and number data types that aren’t aggregatable. See Apply List Filters.

  • 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 Build Expression Filters.