> [!NOTE]
> **Note:** This page is part of the [Retrieve and chart data](https://docs.cloud.google.com/looker/docs/2602/retrieve-and-chart-data) learning series.

This page introduces you to data exploration with Looker. Read the following sections to learn about these Looker concepts:

- [How to find Explores in Looker](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#explores_are_the_starting_point_for_exploration)
- [How to use Quick Start analyses as a starting point for Explores](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#quick_start)
- [How to add fields to Explores](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#adding_more_dimensions_for_more_detail)
- [How to use the field picker](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#field_picker)
- [How to remove fields](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#removing_fields)
- [How to sort data](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#sorting_data)
- [How to pivot data](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#pivoting_dimensions)
- [How to reorder columns](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#reordering_columns)
- [How to display totals](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#displaying_totals)
- [How to view an estimate of the cost of the query](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#cost_estimates_for_explore_queries)
- [How to use the features that are available to developers](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#features_for_developers)
- [How to use the Explore query tracker](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#explore_query_tracker)

For more information about the components on the Explore page and interacting with Explore data, visit the [Viewing and interacting with Explores](https://docs.cloud.google.com/looker/docs/2602/viewing-and-interacting-with-explores) documentation page.

## Explores are the starting point for exploration

An *Explore* is a starting point for a query that is designed to explore a particular subject area. To open the **Explore** menu, select the **Explore** option from the [main navigation panel](https://docs.cloud.google.com/looker/docs/2602/finding-content).

The **Explore** menu presents a number of descriptive model or group names that are organized in alphanumeric order. From the **Explore** menu, you can search for and select Explores, which are organized alphanumerically under the model or group name to which they belong.

For example, if you operate an e-commerce store, you would use the **Explore** menu to find models or groups that contain Explores that let you view your e-commerce store data.

You can display a list of Explores by expanding or collapsing a model or group name within the **Explore** menu. You can open an Explore page by selecting the name of an Explore.

For example, the **A Ecommerce** store model includes the Explores **Order Items** (the products that are associated with an order), **Orders** (purchase events), **Products** (information about inventory products), and **Users** (individuals who are associated with purchase events). When you have questions about items that are associated with an order, you might want to select the **Order Items** Explore.

![](https://docs.cloud.google.com/static/looker/docs/images/explore-explore-menu-2-2218.png)

Explores contain *views* , which are groupings of dimensions and measures. The data that is shown in an Explore is determined by the dimensions and measures that you select from the views that are listed in the field picker at the left. A *dimension* can be thought of as a group or a bucket of data. A *measure* is information *about* that bucket of data. In the Explore data table, dimensions appear as blue columns and measures appear as orange columns.

For example, to display the number of orders that are placed per day, a user can select the dimension **Created Date** and the measure **Count** from the **Orders** view in the **Order Items** Explore.

![](https://docs.cloud.google.com/static/looker/docs/images/explore-orders-by-day-2406.png)

If an Explore contains [modeled queries](https://docs.cloud.google.com/looker/docs/2602/reference/param-explore-query), you can use Quick Start analyses to populate fields. The next section provides an in-depth overview of Quick Start analyses and how to use them as a starting point for exploring data.

## Quick Start analyses

[Modeled queries](https://docs.cloud.google.com/looker/docs/2602/reference/param-explore-query) are available as Quick Start analysis options in Explores. Quick Start analyses provide a helpful starting point for quickly running and building analyses.

Quick Start analyis cards are displayed to the right of the field picker in a blank Explore. Each Quick Start analysis card displays the name of the analysis and, when available, a [description](https://docs.cloud.google.com/looker/docs/2602/reference/param-explore-query#description).

More information on how developers can model prebuilt analyses for users is available on the [`query`](https://docs.cloud.google.com/looker/docs/2602/reference/param-explore-query) parameter documentation page.

### Choosing a Quick Start option from a blank Explore

To run a Quick Start analysis, select the analysis option that you want to explore. The query will automatically run and display results, including the visualization.

You can modify a Quick Start analysis once it has run by [adding](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#adding_more_dimensions_for_more_detail) or [removing](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#removing_fields) fields from the [**All Fields**](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#all_fields_tab) tab, from [**Search**](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#search_bar) results, or from the [**In Use**](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#in_use_tab) tab in the [field picker](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#new_explore_field_picker).

### Choosing a Quick Start option once an Explore has run

Once an Explore has finished running, you can select a new Quick Start analysis by selecting the **Quick Start** lightning bolt icon next to the Explore name.

Selecting this icon opens the **Quick Start** menu that displays the available analysis cards.

Selecting a Quick Start analysis from the menu runs the analysis and replaces all the previous Explore results except the existing filters.

#### Quick Start filter behavior

Filters are additive. This means that, when run, Quick Start analyses will include any existing Explore filters. If a selected Quick Start analysis has a filter value that conflicts with an existing Explore filter, you will be prompted to select which filter value to use in the analysis.

For example, you are currently viewing the results of an Explore query that include these filters:

- **Orders Created Date** is in the year "2019".
- **Orders Status** is equal to "complete".
- **Users State** is equal to "Washington".

You want to select a new Quick Start analysis called **CA order count by month** that will display the number of orders placed in California by month in the year 2019.

![](https://docs.cloud.google.com/static/looker/docs/images/quick-start-filter-conflict-start-explore-2406.png)

You select the **Quick Start** lightning bolt icon to open the Quick Start menu and select the **CA order count by month** analysis option:

![](https://docs.cloud.google.com/static/looker/docs/images/quick-start-filter-conflict-analysis-select-2220.png)

The **CA order count by month** analysis has a conflicting filter value for the **Users State** filter. The **Choose filter set** menu opens, and you're prompted to resolve the conflict by selecting either the **Keep current filters** option, which lists the current filter values, or the **Replace with new filters** option, which lists the filter values of the selected Quick Start analysis.

![](https://docs.cloud.google.com/static/looker/docs/images/quick-start-filter-conflict-filter-select-2100.png)

To resolve the conflict in the **Choose filter set** menu, follow these steps:

1. Choose an option.
   - Choose **Keep current filters** to run the new analysis with the existing filter value (**Users State** is equal to "Washington" in this case).
   - Choose **Replace with new filters** to run the new analysis with its prebuilt filter condition (**Users State** is equal to "California" in this case).
2. Select **Apply** to confirm the selection and run the analysis.

The Explore runs with the updated **Users State** is equal to "California" filter condition, and it includes any existing non-conflicting filters (**Orders Created Date** is in the year "2019" and **Orders Status** is equal to "complete").

![](https://docs.cloud.google.com/static/looker/docs/images/quick-start-filter-conflict-end-explore-2304.png)

## Adding more dimensions for more detail

Whether you added fields to your Explore manually or by selecting a [Quick Start](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#quick_start) option, you can add more dimensions to learn more about your data.

To add a field, follow these steps:

1. Select a field from the [field picker](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#field_picker) to add it to the query.
2. Select the **Run** button to re-run the query.

For example, selecting the **Orders Status** dimension in an Explore that contains **Orders Created Date** and **Orders Count** will display the order number of orders that have the status complete, pending, or canceled by day.


## Field picker

The field picker, which is located on the left side of the Explore page, includes the following elements from top to bottom:

![](https://docs.cloud.google.com/static/looker/docs/images/upgraded-explore-field-picker-2410.png)

1. The Explore name displays the name of the current Explore. The **Quick Start** lightning bolt icon will also appear for Explores that have [modeled queries](https://docs.cloud.google.com/looker/docs/2602/reference/param-explore-query), which lets you access [Quick Start](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#quick_start) analysis options after an Explore has run.
2. The [**Find a Field** search bar](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#search_bar) lets users search for fields that match specific terms and criteria.
   - To change the scope of your search, click **Search Options** . You can limit your search to [field labels](https://docs.cloud.google.com/looker/docs/2602/reference/param-field-label), [field descriptions](https://docs.cloud.google.com/looker/docs/2602/reference/param-field-description), [group labels](https://docs.cloud.google.com/looker/docs/2602/reference/param-field-group-label), or [view labels](https://docs.cloud.google.com/looker/docs/2602/reference/param-field-view-label).
3. The [**All Fields** tab](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#all_fields_tab) displays all available fields for an Explore.
4. The [**In Use** tab](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#in_use_tab) displays all Explore fields that are currently in use.
5. The view level summary displays the total number of selected fields from a view. This number is shown when a view is collapsed, and when it is expanded.
6. The [field-specific information and actions icons](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#field-specific_information_and_actions) display a field's current and potential functions in an Explore query, as well as more details about a field.

7. The Explore summary displays the total number of fields in an Explore (including custom fields and table calculations when [permissions](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-roles#create_table_calculations) allow) in the bottom left corner, and the **Go to LookML** link in the bottom right. **Go to LookML** directs users to the `explore` definition in its LookML project. This link is visible only to users with the [`see_lookml`](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-roles#see_lookml) permission.

### Field-specific information and actions

The icons next to each field provide more information about the field and indicate the available options for that field. The icons are visible when you hover a cursor over a field.

You can select an icon to perform several changes to a query with a field depending on the field's data type, including filtering or pivoting by a field. You can also use icons to information about a field, or --- when [permissions](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-roles#create_custom_fields) allow --- to create a custom field that is based on the field.

These icons appear on the [**All Fields**](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#all_fields_tab) and [**In Use**](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#in_use_tab) tabs.

The available icons and functions include the following:

1. **Pivot data** icon ![](https://docs.cloud.google.com/static/looker/docs/images/field-picker-pivot-icon-2300.svg) --- Select this icon to pivot or unpivot a field in an Explore. This icon will appear gray when a field is not pivoted and bold when a field is pivoted.
2. **Filter by field** icon --- Select this icon to [filter](https://docs.cloud.google.com/looker/docs/2602/filtering-and-limiting#basic_filters) query results by a field, or to remove a field as a filter. This icon will appear gray when a field is not an active filter and bold when it is an active filter.

3. **Info** icon info --- Select this icon to open a pop-up to learn more information about a field:

   - The pop-up will display the field's data type, [description](https://docs.cloud.google.com/looker/docs/2602/reference/param-field-description) (when available), and LookML field name (in `view_name.field_name` syntax) for all users.
   - For users with the [`see_lookml`](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-roles#see_lookml) permission, the pop-up will include the definition of the LookML field's [`sql`](https://docs.cloud.google.com/looker/docs/2602/reference/param-field-sql) parameter, as well as a link to navigate to that field in the LookML project.


4. The three-dot **More** menu is available to users in certain cases:

   - When a user has the [`create_custom_fields`](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-roles#create_custom_fields) permission.
   - When a [dimension group](https://docs.cloud.google.com/looker/docs/2602/reference/param-field-dimension-group) is selected in the Explore query. The three-dot **More** menu will appear for dimension groups on the [**In Use**](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#dimension_group_three_dot) tab.

   Users with the `create_custom_fields` permission can use the three-dot **More** menu to quickly create [custom fields](https://docs.cloud.google.com/looker/docs/2602/custom-fields) depending on a field's type.

### All Fields tab

When you open an existing Explore, the **All Fields** tab is displayed by default. This tab is the starting place for building an Explore and displays all the available fields that you can select for a query. Fields are organized alphanumerically by type (dimensions, followed by measures) under the name of the [view](https://docs.cloud.google.com/looker/docs/2602/reference/param-view-view) or [view label](https://docs.cloud.google.com/looker/docs/2602/reference/param-field-view-label) in which they are defined. Each field will show [field-specific information and actions](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#field-specific_information_and_actions), such as a field's current and potential functions in an Explore query.

![An All Fields tab with a cursor hovering over the Profit dimension.](https://docs.cloud.google.com/static/looker/docs/images/explore-new-field-picker-all-fields-tab-2412.png)

Fields that are selected in a query will appear highlighted by a gray background and corresponding field icons (pivot, filter) will appear in bold without you needing to hold the pointer over a field when it is active. For example, the field **Profit** in the preceding field picker example is highlighted in gray, indicating that it is selected. You can tell that this field is not pivoted or filtered because all corresponding field icons are not bold and don't appear when you aren't hovering over the field.

[Select a field](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#adding_more_dimensions_for_more_detail) from the **All Fields** tab to add it to or remove it from an Explore query. Additionally, you can select the appropriate field icon to filter, pivot, or perform other [field-specific actions](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#field-specific_information_and_actions) from the **All Fields** tab.

[Custom fields](https://docs.cloud.google.com/looker/docs/2602/custom-fields) and [table calculations](https://docs.cloud.google.com/looker/docs/2602/table-calculations) are listed under the **Custom Fields** view label. Users with the [`create_table_calculations`](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-roles#create_table_calculations) permission can create and edit table calculations, and users with the [`create_custom_fields`](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-roles#create_custom_fields) permission can create and edit custom fields by selecting the **Add** button next to the view label, or by choosing a custom field option from a field's three-dot [**More**](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#three-dot_more_menu) menu.

> [!CAUTION]
> **Caution:** Users *must have* the `create_custom_fields` permission to see the three-dot **More** menu. The only exception is for [dimension groups](https://docs.cloud.google.com/looker/docs/2602/reference/param-field-dimension-group) in the [**In Use**](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#dimension_group_three_dot) tab.

### In Use tab

The **In Use** Tab shows all fields that are currently active in an Explore, organized alphanumerically by [view](https://docs.cloud.google.com/looker/docs/2602/reference/param-view-view) or [view label](https://docs.cloud.google.com/looker/docs/2602/reference/param-field-view-label), and whether they are dimensions or measures:

![In Use tab displaying the custom field Sum of Profit, Order Items Cost, Order Items Count, and Orders Created Date selected.](https://docs.cloud.google.com/static/looker/docs/images/explore-new-field-picker-in-use-tab-2406.png)

The **In Use** tab also displays an updated Explore summary at the bottom of the tab. The bottom left corner displays the total number of active fields in an Explore. A **Go to LookML** link is available in the bottom right to users with the [`see_lookml`](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-roles#see_lookml) permission. **Go to LookML** directs users to the `explore` definition in its LookML project. The preceding example shows that there are currently four total active fields in the Explore.

#### Removing fields from the In Use tab

When a field is in use, you can remove it from an Explore by selecting the field's name from the field picker.

You can also remove all selected fields (including custom fields and table calculations) by selecting **Clear all** , or you can remove all fields (including custom fields and table calculations), except those that are active filters, by selecting **Clear fields, keep filters** . Neither of these options will remove [Custom filters](https://docs.cloud.google.com/looker/docs/2602/filtering-and-limiting#adding_a_custom_filter); to remove a custom filter you need to manually uncheck the checkbox next to the filter.

Alternatively, you can choose to filter, pivot, or perform other [field-specific actions](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#field-specific_information_and_actions) from the **In Use** tab by choosing the appropriate field icon.

#### In Use tab field-specific icons and actions

The [icons](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#field-specific_information_and_actions) that are next to each field indicate the field's current and potential functions in an Explore query. [Custom fields](https://docs.cloud.google.com/looker/docs/2602/custom-fields) and [table calculations](https://docs.cloud.google.com/looker/docs/2602/table-calculations) are listed under the **Custom Fields**
view label when they are used in an Explore. Users with the [`create_table_calculations`](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-roles#create_table_calculations) permission can create and edit table calculations, and users with the [`create_custom_fields`](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-roles#create_custom_fields) permission can create and edit custom fields by selecting the **Add** button or by choosing a custom field option from a field's three-dot [**More**](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#three-dot_more_menu) menu.

Users *must have* the `create_table_calculations` or `create_custom_fields` permission to see the three-dot **More** menu. The only exception is for [dimension groups](https://docs.cloud.google.com/looker/docs/2602/reference/param-field-dimension-group) in the **In Use** tab --- the three-dot **More** menu will appear for dimension groups that appear in the **In Use** tab.

When a dimension group is active in an Explore's data table, users can use the three-dot **More** menu to access the **Switch to** list to replace a selected timeframe with another, if available, without having to manually deselect one field and select another field:

![Switch to menu for Orders Created Date displaying Month, Quarter, Week, Time, and Year timeframe options.](https://docs.cloud.google.com/static/looker/docs/images/explore-new-field-picker-in-use-tab-switch-to-date-2404.png)

When you select a new timeframe from the **Switch to** list, the Explore automatically reruns with updated results. When you're using the **Switch to** function, only timeframes in the Explore data table, not filtered timeframes, will be replaced.

### Search bar

The search function empowers you to quickly select the specific fields you need to build Explores.


#### Entering a search term in the search bar

Entering a string in the search bar will filter the field picker to display only the fields, views, and fields with descriptions that match all or part of a search string.

To perform a search, begin by entering a term. You can also select the **Search Options** link to choose an option for limiting your search:

- **Any** --- Select this option to search the field picker without restriction for the term you entered. This is the default for Explores that contain 5,000 or fewer fields.

  > [!NOTE]
  > **Note:** The **Any** option is available for all Explores, but can be less performant for very large Explores. We recommend using a different option for Explores containing more than 5,000 fields.

- **Field Label** --- Select this option to limit your field picker search to field names. This is the default for Explores that contain more than 5,000 fields.

- **Field Description** --- Select this option to limit your field picker search to field descriptions.

- **Dimension Group** --- Select this option to limit your field picker search to dimension groups.

- **View Name** --- Select this option to limit your field picker search to view names.

> [!TIP]
> **Tip:** Wrap your search term in quotes for exact matches. Otherwise, the search function will perform a "fuzzy" search and return fields with terms that are similar to the term that you entered along with fields that contain the exact term.

The filtered field picker features the same functionality as described in the [**All Fields** tab](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#all_fields_tab) section.

## Removing fields

To remove a field from an Explore:

1. Select the desired field in the field picker or choose **Remove** from the column's gear menu in the Explore data table.
2. Select the **Run** button to re-run the query.

You can also remove all fields in an Explore using the [keyboard shortcuts](https://docs.cloud.google.com/looker/docs/2602/keyboard-shortcuts) Command-K (Mac) or Ctrl+K (Windows).

## Sorting data

> Some sorting in Explores is performed on the client side (in the user's browser) to reduce the number of round-trip calls to databases, which can be both costly and time consuming. However, this behavior can lead to inconsistencies between Explore results and other Looker content, as sorting between client and database can produce different results --- especially if system locales differ.

**Unpivoted** data on the **Explore** page is sorted by default according to the following prioritization:

1. The first date dimension, descending
2. If no date dimension exists, the first measure, descending
3. If no measure exists, the first added dimension, ascending

For information on sorting pivoted data, see the [Pivots and sorting](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#pivots_and_sorting) section.

A field's sort order is indicated in the data table in several ways:

- With a number next to the field name that distinguishes its sort-by order as compared to other fields
- With an arrow next to the field name that indicates the sorting direction (pointed up for ascending or down for descending)
- With a pop-up that appears when you hover over a field name

You may want to sort data differently than the default order. You can sort by selecting a field's name in the data table to sort the query by that field:

- Select a field name once to sort by that field in descending order.
- Select a field name twice to sort that field in ascending order.

You can select a field multiple times as necessary to attain the desired sort order.

> [!CAUTION]
> **Caution:** If you reach a [row limit](https://docs.cloud.google.com/looker/docs/2602/filtering-and-limiting#limiting_data), you will not be able to sort [row totals](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#cant-sort-row-totals) or [table calculations](https://docs.cloud.google.com/looker/docs/2602/table-calculations#cannot-sort).

For example, an Explore query with **Orders Created Date** , **Users State** , and **Orders Count** is currently sorted by **Orders Created Date** in descending order.

However, you want to see the date that has the most orders from returning customers (in other words, customers who are not making their first purchases). Select the **Order Items Count** column header to re-sort the query to display the dates that have the highest count of orders to the lowest. A downward arrow next to **Order Items Count** indicates that the results are now sorted by this field, in descending order. Additionally, a pop-up that appears when you hover over a the field name confirms the sort order:

![Pop-up over the Order Items Count field name displaying the text Descending, Sort Order: 1.](https://docs.cloud.google.com/static/looker/docs/images/explore-sorting-by-one-field-2316.png)

### Sorting by multiple fields

To sort multiple fields, hold down the Shift key and then select the column headers in the order that you want them sorted.

![Explore query with the fields Orders Created Date, Users State, and Orders Count sorted by Orders Count descending and by Orders Created Date descending.](https://docs.cloud.google.com/static/looker/docs/images/explore-multi-sort-2308.png)

The arrows next to **Orders Created Date** and **Order Items Count** field names indicate that the table is sorted by both fields, and the order by which the table is sorted. **Orders Created Date** is the second order-by field (descending), as indicated by the downward-pointing arrow and **2** next to the field name.

You can also create custom sorting using the [`case`](https://docs.cloud.google.com/looker/docs/2602/reference/param-field-case) parameter.

## Pivoting dimensions

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. Looker supports up to 200 pivoted values.

To pivot Explore results by a dimension:

1. Hover over the dimension in the field picker and Select the [**Pivot data** icon](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#pivot_icon).
2. Select **Run** to re-run the query.
3. You can unpivot a field in one of two ways:
   - By selecting the **Unpivot** option from the field's gear icon menu at the top of the column in the data table
   - By selecting the dimension's **Pivot data** icon again in the field picker

### Pivots and nulls

A row of data whose value would not appear in a column is indicated with the null value symbol, a zero with a slash across it. For example, on December 21st, there were no completed orders:

![Explore query with Orders Created Date and Orders Count pivoted by the Orders Status field values cancelled and complete.](https://docs.cloud.google.com/static/looker/docs/images/explore-row-totals-cropped-for-nulls-2220.png)

### Pivots and sorting

You can also sort pivoted dimensions by selecting the title of the dimension in the data table. To sort by multiple pivoted dimensions, hold down the Shift key and then select 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).

You can also create custom sorting using the [`case`](https://docs.cloud.google.com/looker/docs/2602/reference/param-field-case) parameter.

## Reordering columns

You can reorder columns in the **Data** section by selecting a column header and dragging and dropping the column to its desired position. The Explore's visualization will reflect the new column order after you select the **Run** button.

Columns are organized in the **Data** section by field type:

1. Dimensions
2. Dimension [table calculations](https://docs.cloud.google.com/looker/docs/2602/table-calculations)
3. Measures
4. Measure [table calculations](https://docs.cloud.google.com/looker/docs/2602/table-calculations)
5. [Row totals](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#displaying_totals)

For the most part, columns can be reordered within each field type but cannot be moved out of their field type section.

For example, dimension table calculations can be rearranged among themselves, but you cannot place a dimension table calculation in between two measures.

One exception, however, is that you can use the arrow next to the row totals checkbox on the **Data** tab to move the row total column from the far right of the data table to just after the dimension table calculations.

Columns under a pivoted dimension can be reordered, but the order of pivoted dimensions can be changed only by changing the sort order, not by manual reordering.

## Displaying totals

Sometimes a summary of your data is useful. You can add column totals to an Explore query by checking the **Totals** checkbox in the upper right of the Explore data table and then rerunning the query.

![](https://docs.cloud.google.com/static/looker/docs/images/explore-column-totals-2220.png)

If an Explore query contains more than one dimension, you can choose to include [**Subtotals**](https://docs.cloud.google.com/looker/docs/2602/table-options#subtotals) in your table visualization by checking the **Subtotals** checkbox in the upper right of the Explore data table next to the **Totals** checkbox. The **Subtotals** checkbox only appears when your query includes more than one dimension.

![](https://docs.cloud.google.com/static/looker/docs/images/explore-column-subtotals-2302.png)

You can also add row totals to a pivoted Explore query by checking the **Row Totals** checkbox in the upper right of the data table. The **Row Totals** checkbox is only available if an Explore query includes a pivoted dimension.

![](https://docs.cloud.google.com/static/looker/docs/images/explore-row-totals-2302.png)

If you've added row totals, and your query exceeds any [row limit](https://docs.cloud.google.com/looker/docs/2602/filtering-and-limiting#limiting_data) that you've set, you will not be able to sort the **Row Totals** column (although you can sort dimension and measure columns as normal). This is because you might be missing rows in your data that should be included in your totals. If you run into this issue, you can try increasing the query's row limit (up to 5,000 rows).

### When totals aren't available

There are some cases when totals won't be available:

- Column totals are available only for measures and table calculations that exclusively reference measures, not for dimensions or table calculations that reference dimensions.
- Row totals are available only for measures, not for table calculations that are based on dimensions or dimensions.
- Certain types of columns won't be totaled, because of database limitations or because the value would not make sense as a total. For example, you can't add together a list of words.

### Things to consider with totals

Additionally, there are some things to keep in mind about how totals work in certain situations:

- Columns that count unique items might not add up as you expect, since the same item might show up in several categories but be counted as only one unique item in the totals.
- The **Row Totals** feature creates an additional query, and this query has a limit of 30,000 rows. If your Explore query has more than 30,000 rows, row totals will be shown for the first 30,000 rows only. Furthermore, if the data is [pivoted](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#pivoting_dimensions), the row totals limit is further reduced by the number of options in your pivot.
- Some [table calculations](https://docs.cloud.google.com/looker/docs/2602/table-calculations) that perform aggregations, such as calculations that use `percentile` or `median`, might not add up as you expect. This is because table calculations calculate totals by using the values in the **Total** row, not the values in the data column. See the [Display potentially confusing table calculation totals as nulls](https://docs.cloud.google.com/looker/docs/2602/best-practices/how-to-display-confusing-table-calculation-totals-as-nulls) Best Practices page for troubleshooting tips.
- If you've [filtered](https://docs.cloud.google.com/looker/docs/2602/filtering-and-limiting#filtering_data) your query by a measure, totals may appear to be too high. However, in actuality, what you're seeing is a total for your data *before* the measure filter is applied. In other words, the measure filter may be hiding some data from your query results, even though that data is included in the total.
- If you've used totals with [merged results](https://docs.cloud.google.com/looker/docs/2602/merged-results), Looker calculates totals on each of the component queries and uses those totals in the merged result. Therefore, totals may appear too high, because what you are seeing are totals calculated before the [results were merged](https://docs.cloud.google.com/looker/docs/2602/merged-results#what_if_one_query_doesnt_have_a_matching_data_value). One way to avoid this is to align the filters on each query.
- Similarly, if you've placed row or column [limits](https://docs.cloud.google.com/looker/docs/2602/filtering-and-limiting#limiting_data) on your query, and your query results exceed that limit, totals may also appear to be too high. However, what you're seeing is a total for your data *before* the limits are applied. In other words, the limits may be hiding some data from your query results, even though that data is included in the total.

In the situations described in the third and fourth bullets in the preceding list, it is possible to calculate totals *only* for the data you can see. To do so, you'll need to use a table calculation, explained later on this page. For a column total, use `sum(${view_name.field_name})`. For a row total, use `sum(pivot_row(${view_name.field_name}))`.

> [!NOTE]
> **Note:** For information about displaying subtotals in table visualizations, see the [Table chart options](https://docs.cloud.google.com/looker/docs/2602/table-options#subtotals) documentation page.

## Cost estimates for Explore queries

For [BigQuery](https://docs.cloud.google.com/looker/docs/2602/db-config-google-bigquery), [MySQL](https://docs.cloud.google.com/looker/docs/2602/db-config-mysql-mariadb-singlestore), [Amazon RDS for MySQL](https://docs.cloud.google.com/looker/docs/2602/db-config-mysql-on-amazon-rds), [Snowflake](https://docs.cloud.google.com/looker/docs/2602/db-config-snowflake), [Amazon Redshift](https://docs.cloud.google.com/looker/docs/2602/db-config-amazon-redshift), [Amazon Aurora](https://docs.cloud.google.com/looker/docs/2602/db-config-amazon-aurora-mysql), [PostgreSQL, Cloud SQL for PostgreSQL, and Microsoft Azure PostgreSQL](https://docs.cloud.google.com/looker/docs/2602/db-config-postgresql) connections, the Explore page provides an estimate of the cost of the query. Select one or more fields from the field picker and refrain from running the query immediately. The Explore page will calculate the amount of data that the query will require and display the information near the **Run** button.

![The text Will process 56.0 KB next to the query timezone under the run button of the Explore.](https://docs.cloud.google.com/static/looker/docs/images/explore-cost-estimate-2216.png)

> [!NOTE]
> **Note:** For BigQuery, MySQL, and Amazon RDS for MySQL connections, cost estimates are always enabled. For Snowflake, Amazon Redshift, Amazon Aurora, PostgreSQL, Cloud SQL for PostgreSQL, and Microsoft Azure PostgreSQL database connections, you must enable the [**Cost Estimate**](https://docs.cloud.google.com/looker/docs/2602/connecting-to-your-db#cost_estimate) option for the connection. You can enable **Cost Estimate** when you [create the connection](https://docs.cloud.google.com/looker/docs/2602/connecting-to-your-db#creating_a_new_database_connection). For existing connections, you can [edit the connection](https://docs.cloud.google.com/looker/docs/2602/admin-panel-database-connections#editing_connections) from the [**Connections**](https://docs.cloud.google.com/looker/docs/2602/admin-panel-database-connections) page in the **Database** section of Looker's **Admin** panel.

The Explore page displays different information depending on the query:

- For new queries on the database, the Explore page displays the number of bytes that will be processed.
- For queries that can be pulled from the [cache](https://docs.cloud.google.com/looker/docs/2602/caching-and-datagroups#how_looker_uses_cached_queries), the Explore page displays the number of rows that will be pulled from the cache.
- For queries that use [aggregate awareness](https://docs.cloud.google.com/looker/docs/2602/aggregate_awareness) optimization, the Explore page displays the number of bytes that will be processed and the number of bytes that will be saved by using aggregate awareness.

The calculation of cost estimates is dialect specific. Use Looker's [`EXPLAIN`](https://docs.cloud.google.com/looker/docs/2602/sql-runner-manage-db#examining_an_execution_plan_using_explain) function to see how a query is processed by your database.

## Features for developers

Depending on your [permissions](https://docs.cloud.google.com/looker/docs/2602/admin-panel-users-roles#permissions_list), you may see several features designed for Looker developers in the Explore [field picker](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#field_picker):

- The **Go to LookML** option on the [**All Fields**](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#explore_summary) and [**In Use**](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#in_use_tab) tabs lets developers navigate to the Explore's LookML.
- The `sql` parameter definition in a field's [**Info** icon menu](https://docs.cloud.google.com/looker/docs/2602/creating-and-editing-explores#info_icon) lets developers see a field's `sql` definition without needing to navigate to the field's LookML.
- The **Go to LookML** option in a field's **Info** icon menu lets developers see the field's LookML.

You may also see several features in the Explore's data table gear menu for fields and in the **Explore actions** gear menu:

- The **Go to LookML** option in a field's data table gear menu lets Looker developers navigate to the field's LookML definition.
- The **SQL** tab in the Explore's **Data** section lets Looker developers see [the SQL query](https://docs.cloud.google.com/looker/docs/2602/how-looker-generates-sql#viewing_the_query) that Looker sends to the database to retrieve the data.
- The **Get LookML** option in the [**Explore actions** gear menu](https://docs.cloud.google.com/looker/docs/2602/viewing-and-interacting-with-explores#the_explore_actions_gear_menu) lets developers copy LookML for the Explore's query, which can be used to add a tile to [LookML dashboards](https://docs.cloud.google.com/looker/docs/2602/building-lookml-dashboards#adding_a_visualization_to_an_existing_lookml_dashboard), to improve query performance with [aggregate tables](https://docs.cloud.google.com/looker/docs/2602/reference/param-explore-aggregate-table#getting_aggregate_table_lookml_from_a_dashboard), or to define [native derived tables](https://docs.cloud.google.com/looker/docs/2602/creating-ndts#using_an_explore_to_begin_defining_your_ndts).

## Explore query tracker

If either the Explore visualization panel or the data panel is open, the [Explore query tracker](https://docs.cloud.google.com/looker/docs/2602/query-tracker#explore_query_tracker), which lets you view the query's progress, appears while an Explore query is running.

## Conclusion

Now that you know how powerful the Looker **Explore** page is for building queries, displaying results, and discovering insights through iterative searches, you may want to learn how to do the following:

- [Filter and limit](https://docs.cloud.google.com/looker/docs/2602/filtering-and-limiting) your results to just the data you're interested in.
- [Use table calculations](https://docs.cloud.google.com/looker/docs/2602/table-calculations) to create ad hoc Explore metrics.
- [Use custom fields](https://docs.cloud.google.com/looker/docs/2602/custom-fields) to create ad hoc dimensions and measures.
- [Create visualizations](https://docs.cloud.google.com/looker/docs/2602/creating-visualizations).
- [Save Explore queries as Looks](https://docs.cloud.google.com/looker/docs/2602/saving-and-editing-looks).
- [Add Explore queries to dashboards](https://docs.cloud.google.com/looker/docs/2602/creating-user-defined-dashboards#creating_a_dashboard_from_a_look_or_an_explore).
- [Share data](https://docs.cloud.google.com/looker/docs/2602/sharing-data) with other users.