Cross tables are extremely useful while analyzing results. They allow you to observe the relationship between the two questions asked in the survey. The results are presented in the form of a table in which columns and lines form two selected questions with possible answers. Each cell of the table indicates the number of respondents giving a specific combination of responses.

If we want to check how the question was answered by women, and how by men, how answered people living in the countryside, and how in the city, etc. – it will be useful to reach for the cross table. Crossing questions is possible only for closed questions (single and multiple choice).

2. Then select „Create a new cross table” (3).

3. Choose two questions from the list of questions (4).

4. To create a cross table, click Create a cross table (5).

5. In the table created in this way, selecting the % from row field or % from column field will display the percentage value of the given answer in relation to the whole row or column (6).

6. Clicking on Rotate data (transport) (7) will replace the question selected for the row with the question selected for the column and vice versa.

7. After hovering over the result of the cross table, we will see the option Add to report (8) in the upper right year, which allows us to add a cross table to a new or existing report.

8. We can export the created cross table in one of the three formats to choose from (XLSX, CSV). To do this, click Export (9) and then select the desired format.

Cross tables can be defined only for single-choice questions and multiple-choice questions. Thanks to the results filtering function, you can also get data from the intersection of other types of questions.

To learn how to create standard cross tables, go to the rest of the article. If you want to learn more about filtering results, please read the article Results filtering.

First, look at the format of the results depending on whether we use cross tables or filter results to process them. In the example below, we’ll use the gender question (1). At the beginning, we will focus on women.

The result obtained thanks to the cross tables (2):

The result obtained by filtering results:

As you can see in the above screenshots, that regardless of the method, in both cases the results are identical.

It can also be seen that depending on the chosen criterion – gender or age – a different number of filtering is required. In the case of a single choice question, eg a question about sex, only two filters are needed: for a woman and for a man.

In the case of the age question, filtering should be done as many times as possible to answer, e.g. how many age ranges have been included.

Although this type of analysis is quite time-consuming, it allows you to cross any type of question.

In the further part of this article, we will use the example of a short questionnaire containing two single-choice questions – a question about the age and gender of the respondent and a matrix question.

2. In the first field (5), enter the title of the table. We select the first question, in this case the question of single choice about sex (6). In the next window, choose one of the matrix questions (7).

3. After selecting the questions to the table, click „Create a cross table”.

The data segment is called the labels of respondents that can be created in the Contacts or Respondents tab. You can read about how to create labels in this article. Data segments can be crossed with the same questions as when crossing a question with a question.

2. Then select the option: Create a new cross table (3).

3. At the very top of the page, we can give your table a name (4). Next, we choose what we want to include in the table – in this case Data segment (5). From the drop-down list, one of the labels (data segments) previously created for the survey (6) is selected, and below is the question with which we want to cross them (7). Among the supported questions are: single and multiple choice questions, NPS, list and evaluation questions, drag and drop questions (DnD) and single-choice matrix. The whole is saved by clicking the button: Create a cross table (8).

4. After generating the table, it will appear on your screen. To add it to the report, in the upper right corner, click on the option: Add to report.

You should remember that the segments are filtered – only those that have a maximum of 200 unique values ​​will be displayed in the list (ie those that have any sense in the analysis). Also: