suggestion_list - Measures

By default, filters run a SELECT DISTINCT(${field}) to populate filter suggestions. Using this parameter will bypass the default behavior and explicitly set the list of filter options.

Syntax

<measure_name>:
  suggestion_list: [<value1>, <value2>, ...]

Properties

object[]

The name of the measure.

Hide measure_name properties

array

An unquoted, comma-delimited list of values to use as filter suggestions.

Examples

status_list:
  aggregate: list
  sql: ${status}
  suggestion_list: [complete, pending]

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

suggestion_list - Measures

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples