Skip to main content
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

​
measure_name
object[]
The name of the measure.

​
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