The basics of exploring data

This page is an introduction to data exploration in Centricity. Read through to understand where to start pulling data in Centricity and how to modify a report to drill further into data.

Start with the Explore menu

The main Explore on the Centricity platform is labeled “Pulse,” where you can generate your own reports using Centricity’s Pulse data. A Pulse Explore is the starting point for a query, designed to explore a particular subject area, such as the data surrounding a specific subcategory or group of subsets. To access the Explore page, use the Explore menu and select an option from the list, such as “Pulse.”

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. Dimensions appear as blue columns and measures appear as orange columns in the data table.

For example, you could select the dimension “Date range” to group the data set to a specific time period. You could then add the measure “Pulse Shift” to display how a subcategory’s Pulse score during the selected time period changed from the previous time period of the same length.

Navigating the Explore field picker

The Explore field picker includes the following elements:

  1. Explore name — Displays the name of the current Explore, such as “Pulse.”

  2. Search bar — Displays the search function.

  3. All Fields tab — Displays all available fields for an Explore.

  4. In Use tab — Displays only those fields that are currently selected and in use.

  5. Field-specific information and actions — Displays a field’s current and potential functions in an Explore, as well as more details about a field.

  6. Explore summary — Displays the total number of fields in an Explore in the bottom left corner, and the “Go to LookML” link in the bottom right. The link directs users to the explore definition in its LookML project. This link is only visible to users with the see_lookml permission.

Field-specific information and actions

The icons next to each field provide more information about the field and indicate options available for that field. These icons appear on the All Fields and In Use tabs, and in the results of a search.

The icons to the right of a field are visible when a field is active in an Explore, or when you hover a cursor over a field that is not active in an Explore. The icons can be clicked to filter or pivot by the field, or to provide more field information.

  1. 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.

  2. Filter icon — Click this icon to add a field as an Explore filter or to remove as a filter. This icon will appear gray when a field is not a filter and blue when it is an active filter.

  3. Information icon — Click this icon to see more detail about a field:

    1. All users will see the field’s data type, description, and LookML field name (in view_name.field_name syntax).

    2. Users with the see_lookml permission will see the definition of the LookML field’s sql parameter, as well as an option to navigate to that field in the LookML project.