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.
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

suggestable lets you disable suggestions for a dimension or filter of type: string when someone uses that field to filter a report. The default value of suggestable is yes, and suggestions are provided when possible. If you set suggestable to no, suggestions will not be made. Filter suggestions only work with dimensions of type: string, so suggestable works only with dimensions of type: string.

Examples

Prevent the name dimension from providing suggestions:

dimension: name { type: string sql: ${TABLE}.name ;; suggestable: no }

Top