Troubleshooting Explore queries

This page outlines common issues encountered when running Centricity’s Explore queries. The following sections expand upon some of the concepts outlined in the Defining Centricity’s data fields documentation page.

Understanding Pulse-Date pairs

There are two main fields that display Pulse measured during a selected date range:

  • Total Pulse

  • Pulse (selected period)

There are also two options for setting the date range of a query:

  • Start Date and End Date filter-only fields

  • Date Date dimensions, of which there are several options (Date, Month, Month Name, Quarter, Week, and Year)

In Centricity queries, these data fields exist as Pulse-Date pairs, requiring you to use them in the following combinations when running queries:

  • The Pulse (selected period) measure with the Start Date and End Date filter-only fields

OR

  • The Total Pulse measure and the Date Date dimensions

In the vast majority of contexts, you can select either Pulse-Date pair to run a query. However, there are two instances in which Centricity requires a specific Pulse-Date pair to display accurate results:

  1. Queries displaying time series data (i.e. line graph showing change in daily Pulse)

  2. Queries using the Pulse Shift or Pulse Shift Percent measures

Time series data and the Total Pulse-Date Date pair

Queries displaying time series data are required to use the combination of a Date Date field (as both a filter and a dimension) and the Total Pulse measure. Note that using either the Start Date/End Date filters or any measure other than Total Pulse (i.e. Pulse (selected period)) will display incomplete results.

The following steps walk you through the process of running a time series line graph, displaying the daily Pulse of the Men’s Bottoms Subcategory over a two-week period:

  1. Select the Subcategory field as a filter. Enter “Men’s Bottoms” into the filter field.

  2. Select Date as both a dimension and a filter. Select “is in range” from the dropdown filter menu, then enter your desired range into the date picker.

  3. Select Total Pulse as a measure

  4. Click the Line icon from the visualization bar 

  5. Run the query

Pulse Shift-Start Date/End Date pair

Queries using the Pulse Shift or Pulse Shift Percent measures are required to use the combination of the Start Date and End Date fields as filters and the Pulse (selected period) measure. Note that using any of the Date Date fields to filter date range will display incomplete Pulse Shift results. Using the Total Pulse measure will also display incomplete results. 

The following steps walk you through the process of running a Pulse Shift query that displays the Pulse Shift, Pulse Shift Percent, and Pulse of all Subsets of the Men’s Bottoms Subcategory during a two-week span:

  1. Select the Subcategory field as a filter. Enter “Men’s Bottoms” into the filter field.

  2. Select the Subset field as a measure.

  3. Select both the Start Date and End Date filter-only fields. Enter your desired start date and end date in the respective filter fields. 

  4. Select Pulse Shift, Pulse Shift Percent, and Pulse (selected period) as measures. 

  5. Click the Table icon from the visualization bar

  6. Run the query

Note that the Pulse Shift Percent column defaults to displaying data as a decimal, rather than a percentage. You can change these display settings in the Series menu options.

Running a heatmap query

Centricity’s heatmaps allow you to display geolocated Pulse data, aggregated by county, during the selected date range. Heatmaps will only run correctly if you include geographic data in the query. To do so, select either the County FIPS(blue star) or State(blue star) field from the Geography data model dropdown.

The following steps will walk you through the process of running a heatmap query that displays the geolocated Pulse data for the Men’s Bottoms Subcategory in California counties:

  1. Select County FIPS(blue star) as a measure from the Geography data model dropdown

  2. Select State Abbreviation as a filter. Enter “CA” into the filter’s input bar.

  3. Select the Subcategory field as a filter. Enter “Men’s Bottoms” into the filter’s input bar.

  4. Select Date as a filter. Select “is in range” from the dropdown filter menu, then enter your desired range into the date picker.

  5. Select Total Pulse as a measure

  6. Click the Map icon from the visualization bar 

  7. Run the query

Note that you can add the County Name field as a dimension to display both the FIPS Code and name of each county in the data table.



Previous: Heatmap visualization options


 

 

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