About Filters and Filter Types

Filters reduce the amount of data shown in visualizations, canvases, and projects. The types of filters you can use are Range, List, Date, and Expression.

Filter types are automatically determined based on the data elements you choose as filters.

  • Range filters are 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. Range filters 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 two incontiguous ranges (for example, revenue less than $100,000 or greater than $500,000). See Applying Range Filters.

  • List filters are applied to data elements that are text data types and non-aggregatable number data types. See Applying 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 Applying Date Filters.

  • Expression filters enable you to define more complex filters using SQL expressions. See Building Expression Filters.