Skip to main content
By default, filters run a SELECT DISTINCT(${field}) to populate filter suggestions. In scenarios where that query may be less performant, or in places where developers may want to curate the suggestion list, this parameter can be used to suggest via an alternative field’s distinct values.

​
Syntax

<dimension_name>:
  suggest_from_field: <view_name>.<field_name>

​
Properties

​
dimension_name
object
The name of the dimension. Dimension names must:
  • Be unique within the view
  • Start with a letter
  • Contain only alphanumeric characters and underscores

​
Examples

Filter-only field with suggestions
filters:
  status:
    type: string
    suggest_from_field: order_items.status
Dimension with alternative suggestions
status_from_an_obscure_subquery:
  sql: status_from_an_obscure_subquery
  suggest_from_field: order_items.status