suggest_from_field

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.

Limitations

This parameter can’t be used with faceting on the same dimension.

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

Hide dimension_name properties

suggest_from_field

string

The field to use for filter suggestions, specified as view_name.field_name.

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

sql

suggest_from_topic

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

suggest_from_field

Limitations

Syntax

Properties

Examples

​Limitations

​Syntax

​Properties

​Examples

Limitations

Syntax

Properties

Examples