This page refers to the
drill_fieldsparameter that is part of a view.
drill_fieldscan also be used as part of a dimension or measure, as described on the
drill_fields(for fields) documentation page.
drill_fields: [field_or_set, field_or_set, …]
Possible Field TypesDimension, Dimension within a Dimension Group, Measure
AcceptsA square-bracketed list of field names or set names
drill_fields parameter controls what happens when a user clicks on the value of a table cell while exploring data. When a user does this, they “drill” into the data, allowing them to see the individual records that make up that cell, limit their query to the cell’s value, or slice the data in a related way.
drill_fields parameter accepts a list of fields, sets, or a combination of both fields and sets.
At the view level,
drill_fields applies the declared drill fields to all measures in the view that do not have
drill_fields defined at the measure level.
Drilling can be disabled by including in the query a dimension with the
can_filter parameter set to
Suppose you have the following LookML:
This will result in the following user experience:
Drilling into the Average Age field, which has its own drill fields defined, displays the ID, Name, City, and State fields. Drilling into the Count field displays the default Traffic Source, Country, and Age fields.