Use Case: Analyzing close-ended data in map format

by Phil A.

This use case examines how to set up your analysis in Advanced Exploration if you want to view metrics on a per-country basis in the format of a map (vs. a standard bar chart, for example), for a specific time period.  

Some common examples that this use case can be used for include:

  • Overall Experience by country
  • Task Completion by country
  • Sample Size by country
  • Any metric you are collecting with your iPerceptions project by country


For this use case, we'll address the following request: 


I want to view my respondents’ average Overall Experience by country.


Step 1: Select the geographical level at which to analyze your data

If IP Address collection is enabled for your iPerceptions project, geolocation variables are automatically populated for each respondent with which you can perform geographically-specific analysis.  These variables are:

  • Resp_GeoCountry
  • Resp_GeoRegion
  • Resp_GeoCity

For this example, select the Resp_GeoCountry variable (Dimension) and drag it to the “Detail” option in the Marks card:


Doing so will automatically update the output to show a world map through which you will be able to perform this analysis.  The markers on the map indicate each of the countries from which a response was collected for your iPerceptions project.


Step 2: Select the variable to be analyzed, and the format in which this data will be shown

The “Color”, “Shape” and “Text” options provided in the Marks card allow you to specify how to show this data in the table or chart.  For this example, the data will be shown in “Color” format.

Since we are looking to obtain the average Overall Experience rating for respondents based on their country, select the “Overall Experience” variable from the Measures menu, and drag it to the “Color” option in the Marks card:


Step 3: Specify how the measure should be calculated in your analysis

By default, when a Measure is added to an analysis, it is calculated as a Sum by default (see image in Step 2).  To convert this measure to an average, right-click this variable, go to “Measures”, then select “Average”:


The colors in the world map will reflect the average Overall Experience rating for the different countries (the higher the Overall Experience rating, the deeper the color). 

To show the average Overall Experience ratings for each of the countries in text format as well, select the “Show Labels” option in the toolbar:


Step 4: Specify your time period

By default, the crosstabs that you create show data for all respondents that completed your survey in the last 3 years.  To focus your analysis on a specific time period, bring the "Time_RespEnd" variable (Dimension) into the Filters card.  


Additional Use Cases

Aggregate Analysis

Cross-Tabbing 2 Dimensions

Cross-Tabbing 1 Dimension And 1 Measure

Analyzing Data For Multi-Select Questions

Analyzing Respondent-Level Open-Ended Responses


Trended Analysis

Trending A Dimension Over Time

Trending A Measure Over Time

Trending A Crosstab Of 2 Dimensions Over Time

Trending A Crosstab Of 1 Measure And 1 Dimension Over Time

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Powered by Zendesk