The 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.
The drill_fields parameter accepts a list of fields, sets, or a combination of both fields and sets.
If a measure uses the drill_fields parameter, any drill fields set at the view level will not be applied to that measure.
Drilling can be disabled in some cases when the can_filter parameter is used.
Once users click a drill field, they are taken into a drill overlay. The data in the overlay has a default sort based on the following prioritization:
- The first date dimension, descending
- If no date dimension exists, the first measure, descending
- If no measure exists, the first added dimension, ascending
The drill_fields (for fields) documentation page details the followings: