drill_fields - Measures

Drill fields allow for curation of the drilling behavior for a given measure, using an array of fields for the subsequent query. Fields can be specified using individual field names, tags, or field sets. Setting this parameter with an empty value (drill_fields: []) removes the drill from the measure. You can also remove drilling in workbooks by hovering over a field in the field picker, clicking , and selecting Edit. When you drill into a measure, Omni removes any measure-based filters from the dashboard or workbook. Drill queries return underlying rows, so the aggregated value you filtered on (for example, “revenue > 10K”) often becomes much smaller at the row level — which can make the drill table look empty or incorrect. To avoid this, Omni automatically converts measure filters into query-level filters during a drill. This preserves the logic of the filter, but applies it to the detailed data rather than the aggregated measure.

Syntax

<measure_name>:
  drill_fields: [<view>.<field>, <view>.<field>, ...]

Properties

object[]

The name of the measure.

Hide measure_name properties

array

An array of field names, tags (using tag:tag_name), or field sets (using set:set_name). Date fields must be quoted.

Examples

Drill with specific fields

count:
  drill_fields:
    [
      users.id,
      users.full_name,
      users.email,
      users.age,
      users.state,
      users.country,
      "users.created_at[date]"
    ]
  aggregate_type: count

Drill with tag

other_count:
  drill_fields: [tag:my_tag]
  aggregate_type: count

Drill with field set

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

Remove drill

count:
  drill_fields: []
  aggregate_type: count

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

drill_fields - Measures

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples