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 1 Dimension And 1 Measure
Analyzing Data For Multi-Select Questions
Analyzing Respondent-Level Open-Ended Responses
Trended Analysis
Trending A Dimension Over Time
Comments