> ## Documentation Index
> Fetch the complete documentation index at: https://docs.omni.co/llms.txt
> Use this file to discover all available pages before exploring further.

# suggest_from_field

> Suggests filter values from an alternative field's distinct values.

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

```yaml theme={null}
<measure_name>:
  suggest_from_field: <view_name>.<field_name>
```

## Properties

<ParamField path="measure_name" type="object[]">
  The name of the measure.

  <Expandable title="measure_name properties" defaultOpen="true">
    <ParamField path="suggest_from_field" type="string">
      The field to use for filter suggestions, specified as `view_name.field_name`.
    </ParamField>
  </Expandable>
</ParamField>

## Examples

```yaml theme={null}
status_list:
  aggregate: list
  sql: ${status}
  suggest_from_field: order_items.status
```