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

<measure_name>:
  suggest_from_field: <view_name>.<field_name>

​
Properties

​
measure_name
object[]
The name of the measure.

​
Examples

status_list:
  aggregate: list
  sql: ${status}
  suggest_from_field: order_items.status