What calculation options are available for survey data?

There are a number of different ways that you can represent your survey data within iCharts. Depending on the question type, it is important to choose a proper combination of chart type, calculation method, measure, and any additional filter element selections. This type of flexibility allows you to get more out of your survey results.

Each initial chart is set by default to automatically display the overall results for each question. Here are some additional examples of how you can chart some of the most common survey question types:

 

  1. Multiple Choice (Only One Answer)

This question type can be quickly charted using Bar, Column, Pie or Line charts. Simpy click on ‘View Chart’ and use ‘Count’ to display the number of actual respondents. Use ‘Count % of Total’ to display the percentage breakdowns of each response. Use ‘Count % of Selected Categories’ to have the percentages re-calculate depending on the labels that are being selected on the Label Axis.

 

  1. Multiple Choice (Multiple Answers)

This question type comes with 2 filter buttons as part of its structure. Click on ‘View chart’ and question options will be automatically displayed on the label axis. Pay attention to the second related filter where you can choose to view all ‘Yes’ or ‘Selected’ responses. There are a few common ways to represent this question type:

  • To show the percentage of respondents who selected one of the label axis options as part of their response, use the following combination:
    • Chart type: Bar or Column
    • Calculation: Count % of Total
  • To show the percentage distribution of how many respondents selected (Yes) versus did not select (No) the individual question label options, put the related response filter into the ‘Compare/cross-tab’ area and use the following combination:
    • Chart type: 100% Stacked Bar or 100% Stacked Column
    • Calculation: Count % of Total

 

  1. Rating Scale
  • To display the Mean (average) rating of each question label option, make the following selections:
    • Chart type: Bar or Column
    • Label: Select the same question again in the measure list
    • Calculation: Mean
  • To chart the percent breakdown of each rating, put the related response filter containing the rating scale into ‘Compare/cross-tab’ mode and make the following selections:
    • Chart type: 100% Stacked Bar or 100% Stacked Column
    • Calculation: Count % of Total
  • To create a chart displaying the total percentage of Top or Bottom Box responses, you can control that within the related response filter containing the ratings. For example, on a 7-point rating scale question, select responses of ‘6’ and ‘7’ as Top 2 Box, in combination with the following:
    • Chart type: Bar or Column
    • Calculation: Count % of Total

 

  1. Matrix of Choices (Only One Answer Per Row)
  • To chart the percent breakdown of each answer for a particular question label option, put the related response filter containing the responses into ‘Compare/cross-tab’ mode and make the following selections:
    • Chart type: 100% Stacked Bar or 100% Stacked Column
    • Calculation: Count % of Total
  • To create a chart displaying the total percentage of Top or Bottom Box responses, you can control that within the related response filter containing those response options. For example, in a question asking respondents about their familiarity with particular stores, select ‘Somewhat Familiar’ and ‘Very Familiar’ to view the percentage of respondents familiar with each of the stores.
    • Chart type: Bar or Column
    • Calculation: Count % of Total

 

  1. Matrix of Choices (Multiple Answers Per Row)

This question type comes with 3 associated filter buttons as part of its structure in order to allow charting flexibility. Click to ‘View chart’ and question options will be automatically displayed on the label axis. Pay attention to the other two related filters where you can choose to view all selected responses by clicking on ‘Yes’ (this means that response option was selected by the survey respondent) in one of them. Use the 2nd related filter to narrow the chart down to a particular sub-grouping. There are a few popular ways to represent this question type.

  • To chart the percent breakdown of how many times each answer was selected for a particular question label option, put the related response filter containing the responses into ‘Compare/cross-tab’ mode and make the following selections:
    • Chart type: 100% Stacked Bar or 100% Stacked Column
    • Calculation: Count % of Total