User Guide Getting Started Help Center Documentation Community Training
Looker
Exploring Data in Looker

This tutorial introduces you to data exploration with Looker. When you finish, you’ll understand where to start pulling data in Looker, how to modify a report to see more detail, and how to drill down to gain deeper insights.

Explores Are the Starting Point for Exploration

For this tutorial, let’s imagine we operate an e-commerce store. The Explore page presents a number of Explores for looking at our e-commerce store data. An Explore is a starting point for a query, designed to explore a particular subject area. To access the Explore page, use the Explore menu to select an Explore:

In our e-commerce store model we have Explores for Users, Products, Orders (a purchase event), Order Items (the products associated with an Order), and Inventory Items (Products in inventory). For example, when we have questions about users, we probably want to start exploring from the Users Explore.

The data shown in an Explore is determined by the dimensions and measures you select from the Field Picker at the left. A dimension can be thought of as a group or bucket of data. A measure is information about that bucket of data. In Looker, dimensions appear as blue columns and measures appear as orange columns in your data table.

The query shown below displays the number of orders per day, by querying the Orders 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 we’ve asked for a count of orders (the measure) for each of those days.

Next let’s add another dimension by using Looker’s query builder.

Adding More Dimensions for More Detail

Let’s see how many orders are from returning customers. Adding the dimension for ORDERS Is First Purchased (Yes/No) splits the counts between first time and returning customers.

Sorting Data

Let’s see which date has the most orders from returning customers (in other words, customers not making first purchases). Clicking on the ORDERS Count column header will sort from highest to lowest. You can sort by multiple columns by holding down the Shift key, then clicking on the column headers in the order you would like them sorted.

Note that if you reach a row limit, you will not be able to sort row totals or table calculations.

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.

To pivot a dimension, click PIVOT for that dimension. Before running the query, be sure that you also have included at least one unpivoted dimension and at least one measure. You can pivot additional dimensions as desired, but must always include at least one unpivoted dimension.

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. For example, on July 23rd we shipped one accessory but no active wear or blazers.

You can also sort pivoted dimensions by clicking the title of the dimension. To sort by multiple pivoted dimensions, hold down the Shift key, then click on the dimension titles in the order you would like them sorted. When 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).

Removing Fields

You can remove a field from your Explore by clicking the selected field in the field picker or by choosing Remove from the column’s gear menu:

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

Once you have removed fields, click Run to get the new query results.

Displaying Totals

Sometimes a summary of your data is useful. You can add column totals to your report by clicking the Totals checkbox in the upper right, then running the report:

You can also add row totals to your report, but only if you’ve added a pivot to your report:

If you’ve added row totals, and your query exceeds any row limit that you’ve set, you will not be able to sort the row totals column (though 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 your row limit (up to 5,000 rows).

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

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

In situations 2 and 3 above, 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 in this tutorial. For a column total use sum(${view_name.field_name}). For a row total use sum(pivot_row(${view_name.field_name})).

Drilling Down Into the Data

Every query result is the starting point for another query. Clicking on any data point will drill down, creating another query refined by the data point you clicked. In the example below, we see that August 2, 2017 has had 189 orders. Clicking on the count of 189 takes us to details about those specific records.

Drilling Deeper …

In the drill overlay, we can see all of the orders placed on August 2, 2017. From here we can:

And Deeper Still …

If we click on the Order History field for Brendon Smith, we see a list of all the orders by Brendon Smith.

Of course, this isn’t the end of the road. Like any query in Looker, the results are linked so you can keep drilling, exploring, and arriving at new insights.

Copying Values

Looker makes it easy to copy all the data from a table column. To do so, hover over a column label, click the gear icon, and then choose Copy Values:

This data can then be pasted into a document or a tool like Excel.

Using Links and Actions

The presence of either links or actions is indicated by three periods following the data in a field.

Using Links

Your Looker developers may have added clickable links to your data:

When you click on the data in the field, Looker provides an option to open the destination of the link. In the example above, the developers added a link to the Brand column. When you click on a brand listing, Looker provides an option to perform a Google search for that brand name.

Using Actions

Your Looker admin and developers can set up an integrated service and tag a field to provide access to that service. Then, when you click that field, you can choose to send your data to that service:

In the example above, the Phone field has a link to the Twilio service. When you click the phone number and select the Twilio action, Twilio prompts you to enter a message. Twilio then sends that message to the phone number.

Features for Developers

Depending on your permissions, you may see two features designed for Looker developers. The purple icon next to each field in the Field Picker provides a Go to LookML link that lets Looker developers see their data modeling code. The SQL tab in the Data section lets them see the query Looker sends to the database to get the data.

Conclusion

Now that you know how powerful the Looker Explore page is for building queries, displaying results, and discovering insights through iterative searches, you might want to limit your results to just the data you’re interested in.

Top