home User Guide Getting Started Help Center Documentation Community Training Certification
Looker keyboard_arrow_down
language keyboard_arrow_down
Legacy field picker

This page describes Looker’s legacy Explore field picker, which must be enabled by an admin to be available to users. Update to the upgraded Explore field picker for smarter search capability, easy view and management of selected fields, Quick Start analyses for Explores with modeled queries, and user experience improvements.

To learn how to create Explores with the new field picker experience, visit the Exploring data in Looker documentation page.

This page discusses how to use the legacy Explore field picker to:

Visit the Exploring data in Looker documentation page to learn more about using Explores to make actionable insights into your data by sorting columns, reordering columns, displaying totals, drilling, copying values, and using links and actions.

Also visit the Table calculations and Custom fields documentation pages to learn how to create ad hoc metrics and fields with the legacy Explore field picker.

Building Explores with the legacy field picker

The data shown in an Explore is determined by the dimensions and measures that you select from the Explore’s field picker.

The following query displays the number of orders per day by querying the Order Items Explore and displaying one dimension (ORDERS Created Date) and one measure (ORDERS Count).

In this case, all order records have been grouped together by day (the dimension). Then a count of orders (the measure) has been requested for each of those days.

Adding fields

You can add more fields to Explore queries to learn more about your data. To add a field to an Explore query:

  1. Click a field from the field picker to add it to the query.
  2. Click Run to re-run the query.

In the preceding example, adding the dimension for Status splits the counts between order statuses.

Adding pivots

Multiple dimensions are often easier to look at when you pivot one of the dimensions horizontally. Each value in the dimension will become a column in your Look. This makes the information easier to consume visually and reduces the need to scroll down to find data.

To pivot Explore results by a dimension:

  1. Click Pivot for that dimension.
  2. Click Run to re-run the query.
  3. To unpivot results, click the field’s gear icon and select the Unpivot option.

If there is no row of data whose value would appear in a column, that is indicated with the null value symbol, a zero with a slash across it. For example, on July 23rd, one accessory was shipped, but no activewear or blazers were shipped.

You can also sort pivoted dimensions by clicking the title of the dimension. To sort by multiple pivoted dimensions, hold down the Shift key and then click on the dimension titles in the order that you want them sorted. When you’re sorting a pivoted measure, any rows with values in that column are sorted first, followed by rows without data in that column (indicated by the null value symbol).

Adding filters

You can restrict the data you’re viewing to items of interest by adding filters. For example, you might limit the results to certain dates, customers, locations, or anything else that is part of your data. Any field in your Looker instance can become a filter.

To filter Explore results by a field:

  1. Click the field’s Filter button in the field picker, or choose Filter from the column’s gear menu. You can also click on a value in the field’s column to filter the data by that value.
  2. Input a filter value.
  3. Click Run to re-run the query.

To remove a filter, click the field’s blue Filter button in the field picker, or the X next to the filter in the filters pane.

See the Filtering and limiting data documentation page for more information about filtering Explores.

Removing fields

To remove a field from an Explore:

  1. Click the selected field in the field picker, or choose Remove from the column’s gear menu.
  2. Click Run to re-run the query.

You can also remove all fields in an Explore using the keyboard shortcuts Command-K (Mac) or Ctrl+K (Windows).

Features for developers

Depending on your permissions, you may see several features that are designed for Looker developers:

  1. The Looker logo next to the Explore lets Looker developers see the Explore LookML.
  2. The gear drop-down menu next to each field in the field picker provides a Go to LookML link that lets Looker developers see the field’s LookML.