home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
Looker documentation will be moving to cloud.google.com in mid-2022!
All the information you rely on will be migrated and all docs.looker.com URLs will be redirected to the appropriate page.
can_filter

Usage

view: view_name {
  dimension: field_name {
    can_filter: yes
  }
}
Hierarchy
can_filter
Possible Field Types
Dimension, Dimension Group, Measure

Accepts
A Boolean (yes or no)

Definition

The can_filter parameter lets you prohibit a dimension or measure from being used as a filter. For example:

dimension: description { can_filter: no }

The default value of can_filter is true, meaning that dimensions and measures can be used as filters as you would expect. However, there may be some cases when a field may be too demanding to search (like a large text description), and in these situations you can prevent that field from being used as a filter. Users will simply not see a FILTER option when they hover over the field.

Note that can_filter cannot be used with:

Additionally, drilling into a field will not be permitted if the drill requires a filterable dimension and the can_filter parameter is set to no. This occurs when you:

See the documentation pages for drill_fields (for fields) and drill_fields (for views).

Top