Drilling into a Look

In Centricity Looks, you can drill into a value on your report. To view your drill down options, click on the three-dot menu next to the value you’d like to further explore.

Note: The example Look we use in this section uses sample data that we invented for the purpose of this document.

In Looks with tables that list categories, subcategories, or subsets, you have the option to drill into a particular line item. Next to the desired line item, click the three-dot menu and select “Drill into.” A pop-up window will appear that show options for taking a more detailed look at data for that line item.

The first option allows you to drill into the data by State, which will open a pop-up window. For datasets where the row limit is reached in the Details window, Centricity will provide a link for downloading the complete set of results. Either way, though, you’ll have the option of downloading the results from drilling into the Look.

Because Centricity provides geolocation data, drill visualizations provide the option to display Drill data as either a Heatmap or a data table. When the default visualization from a drill is not the one you prefer, buttons at the top of the Details window will allow you to switch between the default visualization and a data table.

The second option you’ll see is for drilling into the next level down in Centricity’s product hierarchy. For example, when viewing the “Categories Table” Look, the filter may be set to “Dairy.” The chart would then show data for all Categories within the Dairy department. To drill into data for Subcategories, click the three-dot menu for a particular Category (ie “Greek Yogurt”) and select “Subcategories for GREEK YOGURT.” You’ll then be taken to a dashboard that drills into all Subcategories for Greek Yogurt.

The same rule applies for all four levels of Centricity’s Product Hierarchy, giving you the ability to drill into your data, from Department to Subset.

The third option you’ll see is for drilling into the Facets for a selected Category. This option will take you to a dashboard that breaks down Pulse data for the relevant attributes to the node you selected.

Drilling into a Look’s visualization

Centricity also allows you to find more specific information about a data point by drilling into a Look’s visualization. To do so, click on the section of the visualization you’d like to explore further.

You can choose which type of drill to perform when you click on the item of interest.

In the example above, we’re clicking on a specific point of interest on a Heatmap showing hotspots of Pulse for Extracts, Herbs, Spices and Seasonings. We have two options to choose from:

  1. Drilling into the Category Extracts, Herbs, Spices and Seasonings by State. This option would show us another Heatmap that analyzes statewide and countywide interest in that particular category.

  2. Drilling into the Dashboard option for Subcategories of Extracts, Herbs, Spices and Seasonings would take you to a dashboard that shows Pulse data for all relevant Subcategories.

The drilling options that appear to you will change depending upon the data and visualization you’re using.

Click here for more details on drilling down into data.

Previous: Viewing Looks

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