sets

Defines a list of fields that can be referenced in parameters that accept lists of fields, such as drill_fields. Once defined, you can reference a set with [ set:<set_name> ]. Refer to the Examples section for more information.

Syntax

sets:
  <set_name>:
    - "<view_name>.<field_name>"
    - "<view_name>.<field_name>"
    ...

Properties

set_name

string[]

required

A name that uniquely identifies the field set. The value is an array of field references in the format view_name.field_name.

Examples

Define a field set named revenue

sets:
  revenue:
    - "order_items.id"
    - "order_items.item_id"
    - "order_items.sales_price"

Referencing the revenue set

measures:
  count:
    aggregate_type: count
    drill_fields: [ set:revenue ]

sample_queries

skills

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples