Most fields in the Field Picker are created by your Looker developers. If your Looker admin has enabled the experimental custom fields feature and given you access, you can add new custom dimensions and measures yourself. Unlike table calculations, a new custom field becomes a new Field Picker choice on that Explore for certain users.
There are several ways to create custom fields. This page shows how to create a custom measure that copies an existing measure and adds a filter:
- Expand the view with the measure that you want to copy. In this example, we want to copy the Average Days to Process measure. The measure cannot be a custom measure.
- Click that measure’s gear menu. (To see the gear menu, your admin has to enable custom fields and give you the right to create them.)
- Click Filter Measure.
- Modify the name and provide the filter expression. The editor will help suggest field names and give syntax help for any functions you use. For more details on using this editor, see the Creating Looker Expressions page. You can use any Looker functions and operators that can be used in other custom filters.
- Save your custom measure. Looker puts the new measure in the Custom Fields section of the Field Picker. Like other measures, you can click a custom measure’s name to display it in a query. You also click its Filter button to use it as a filter in a query.
Viewing and Using Custom Fields
If you are allowed to create custom fields, then you can see and edit any custom fields in the Custom Fields section of the Field Picker. If another user creates a custom field and passes you the Explore’s URL, then you can see that custom field in the Field Picker. The URL must include the
qid parameter (such as
You can interact with these custom fields as you would with any other measure or dimension, including filtering on them or adding them to visualizations. (If you create a custom dimension then you can also pivot on that field.) Only users who are allowed to create custom fields can add a custom field to a query in an Explore, Look, or dashboard tile.
If a user cannot create custom fields, then the Field Picker does not display the Custom Fields section and the user cannot add a custom field to a query. However, users do not need any special permissions to see a custom field used in a shared query, Look, or dashboard. Also, users can click Explore from here on a Look or dashboard tile to create a new query using that field. Good naming of fields is important because these users cannot see the definition of a custom field.
Additional Ways to Add Fields
There are several ways to add new fields to your explore:
- Table calculations, which only affect the current query and any modifications of the query. Using the Command-K or Ctrl+K shortcut will clear all table calculations, including custom fields. To reinstate your table calculations, hit the “back” button on your browser. You may also need to re-run your query.
Custom fields, which become part of the Field Picker for some users. You can create a:
- LookML fields, which can only be created by Looker developers.
For More information
Under Construction: We’re working on adding more to this page. In the meantime, check out the Adding a Custom Measure from a Dimension page. That page includes general information about custom fields, including how to delete a custom field and tips for Looker admins and developers (including how to enable custom fields).