Available On: Business Plus
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.
Dimensions are the objects you will be filtering on, such as an Item, Template or property.
A measure is information about that bucket of data.
Measures are fields that provide a numerical measure on the dimension, such as a number or score.
💡 In the Explore Window, dimensions appear as blue columns and measures appear as orange columns in your data table.
Clicking these will add them to your look, and display the data as a column when you click Run.
The query shown below displays the number of work orders per day by querying the Work Order Explore and displaying one dimension (Work Orders Created Date) and one measure (Work Orders Count).
Adding more dimensions for more detail
You can add more dimensions to learn more about your data.
To add a field:
Click a field from the field picker to add it to the query.
Click Run to re-run the query.
Adding the Current Status dimension splits the counts between work order statuses, and displays how many orders are Complete, In Progress, On Hold, or Open.
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:
Hover over the dimension in the field picker and click the pivot icon.
Click Run to re-run the query.
To unpivot results, click the field’s gear icon and select the Unpivot option, or click the dimension’s pivot icon again in the field picker.
TIP: Pivot icon — Click this icon to pivot or unpivot a field in an Explore. This icon will appear gray when a field is not pivoted and blue when a field is pivoted.
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 June 5th, there were no In Progress or On Hold work orders created:
Pivots and sorting
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).