suggestable

Usage

view: view_name {
  dimension: field_name {
     suggestable 
 : 
 yes 
  }
}
Hierarchy
suggestable
Possible Field Types
Dimension, Dimension Group, Measure, Filter, Parameter
Accepts
A Boolean (yes or no)

Definition

When a user filters an Explore on a field that supports suggestions , by default Looker will suggest possible values for the field (see Changing filter suggestions for information about how you can affect filter suggestions).

The suggestable parameter lets you disable suggestions for a field when a user filters on that field in a Look or an Explore. The default value of suggestable is yes , and suggestions are provided when possible. If you set suggestable to no , Looker won't suggest values for the field.

Examples

Prevent Looker from providing filter value suggestions for the name dimension:

 dimension: name {
  type: string
  sql: ${TABLE}.name ;;
  suggestable: no
} 
Design a Mobile Site
View Site in Mobile | Classic
Share by: