Dimension, Dimension within a Dimension Group, Measure
Accepts
A square-bracketed list of field names or set names
Definition
Thedrill_fieldsparameter 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.
Thedrill_fieldsparameter accepts a list of fields,sets, or a combination of both fields and sets.
At the view level,drill_fieldsapplies the declared drill fields to all measures in the view that do not havedrill_fieldsdefinedat the measure level.
Drilling can be disabled by including in the query a dimension with thecan_filterparameter set tono.
Drilling into theAverage Agefield displays theID,Name,City, andStatefields. Drilling into theCountfield displays the defaultTraffic Source,Country, andAgefields.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-22 UTC."],[],[],null,["# drill_fields (for views)\n\n\u003cbr /\u003e\n\n\u003e This page refers to the `drill_fields` parameter that is part of a [view](/looker/docs/reference/param-view-view).\n\u003e\n\u003e `drill_fields` can also be used as part of a [dimension](/looker/docs/reference/param-field-dimension) or [measure](/looker/docs/reference/param-field-measure), described on the [`drill_fields` (for fields)](/looker/docs/reference/param-field-drill-fields) parameter documentation page.\n\nUsage\n-----\n\n```\nview: view_name {\n drill_fields: [field_or_set, field_or_set, …]\n}\n```\n\nDefinition\n----------\n\nThe `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.\n\nThe `drill_fields` parameter accepts a list of fields, [sets](/looker/docs/reference/param-view-set), or a combination of both fields and sets.\n\nAt 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](/looker/docs/reference/param-field-measure).\n\nDrilling can be disabled by including in the query a dimension with the [`can_filter`](/looker/docs/reference/param-field-can-filter) parameter set to `no`.\n\nExample\n-------\n\nSuppose you have the following LookML: \n\n view: orders {\n drill_fields: [source*, age]\n measure: count {\n type: count\n }\n measure: average_age {\n type: average\n sql: ${age} ;;\n drill_fields: [id, name, city, state]\n }\n set: source {\n fields: [traffic_source, country]\n }\n }\n\nDrilling into the **Average Age** field displays the **ID** , **Name** , **City** , and **State** fields. Drilling into the **Count** field displays the default **Traffic Source** , **Country** , and **Age** fields."]]
