Send feedback
suggestable
Stay organized with collections
Save and categorize content based on your preferences.
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.
Note: If the field's view is defined with suggestions:no
, Looker won't provide suggestions for any field in the view, even if the field is defined with suggestable:yes
.
Examples
Prevent Looker from providing filter value suggestions for the name
dimension:
dimension: name {
type: string
sql: ${TABLE}.name ;;
suggestable: no
}
Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-10-01 UTC.
[{
"type": "thumb-down",
"id": "hardToUnderstand",
"label":"Hard to understand"
},{
"type": "thumb-down",
"id": "incorrectInformationOrSampleCode",
"label":"Incorrect information or sample code"
},{
"type": "thumb-down",
"id": "missingTheInformationSamplesINeed",
"label":"Missing the information/samples I need"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]
Need to tell us more?
{"lastModified": "Last updated 2024-10-01 UTC."}
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-10-01 UTC."]]