default_drill_query - Views

Sets the default drill query for all measures in a view. Refer to the Measure documentation for more information.

Syntax

default_drill_query:
  fields: [ <field1>, <field2> ... ]
  base_view: <view_name>
  limit: number
  sorts: [ <view>.<field>, ... ]

object

An object containing maps that describe how to build the default drill query.

Hide default_drill_query properties

array

An array of fields to include in the drill query.

string

The table that will act as the FROM clause of the query.

number

The number of rows to return in the drill query.

array

An array of fields used to sort the query, specified as view_name.field_name.

Default drill query configuration for orders

default_drill_query:
  fields: [ sale_price, margin ]
  base_view: orders
  limit: 10
  sorts: [ orders.user_id ]

⌘I