> ## Documentation Index
> Fetch the complete documentation index at: https://docs.omni.co/llms.txt
> Use this file to discover all available pages before exploring further.

# drill_fields

> Curates the drilling behavior for a measure.

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](/modeling/models/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 <Icon icon="ellipsis-vertical" iconType="solid" />, 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

```yaml theme={null}
<measure_name>:
  drill_fields: [<view>.<field>, <view>.<field>, ...]
```

## Properties

<ParamField path="measure_name" type="object[]">
  The name of the measure.

  <Expandable title="measure_name properties" defaultOpen="true">
    <ParamField path="drill_fields" type="array">
      An array of field names, tags (using `tag:tag_name`), or [field sets](/modeling/models/sets) (using `set:set_name`). Date fields must be quoted.
    </ParamField>
  </Expandable>
</ParamField>

## Examples

```yaml title="Drill with specific fields" theme={null}
count:
  drill_fields:
    [
      users.id,
      users.full_name,
      users.email,
      users.age,
      users.state,
      users.country,
      "users.created_at[date]"
    ]
  aggregate_type: count
```

```yaml title="Drill with tag" theme={null}
other_count:
  drill_fields: [tag:my_tag]
  aggregate_type: count
```

```yaml title="Drill with field set" theme={null}
count_that_uses_field_sets:
  aggregate_type: count
  drill_fields: [ set:revenue ]
```

```yaml title="Remove drill" theme={null}
count:
  drill_fields: []
  aggregate_type: count
```