suggest_from_field - Dimensions

Specifies an alternative field to use for filter suggestions. 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.

See Customizing filter suggestions for more information about filter suggestions.

Limitations

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

Syntax

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

Properties

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

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

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

suggest_from_field - Dimensions

Limitations

Syntax

Properties

Examples

​Limitations

​Syntax

​Properties

​Examples

Limitations

Syntax

Properties

Examples