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 Run Pulse Query, 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 and run a query with Pulse data, use the Explore menu and select Run Pulse Query.

The data shown in an Explore is determined by the dimensions, measures, and filters 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.

You can select dimensions and measures as filters to restrict the data you display in your query. Centricity also has filter-only fields, which are used to set the Start Date and End Date of your query.

The query shown below displays the Total Pulse per Category in Grocery during the month of February by displaying one dimension (Category), one measure (Total Pulse), and three filters (Start Date, End Date, and Department).

Navigating the Explore field picker

The first step in learning how to run a query is understanding how to navigate 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. View level summary — Displays the total number of selected fields from a view. This number is shown when the view is collapsed, and when it is expanded.

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

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



 

 

More questions about Centricity? Check out our website or talk to our Support Team.