The Advanced option allows the user to create complicated tables/crosstabs which might involve nesting or multiple top breaks and side breaks, vis a vis the Wizard options which you can use to create simple crosstabs.
To create an advanced crosstab, click on 'Advanced' (circled in red). Please note that a Collection has to be created first. (Click Here to know about how to create a collection).
This opens the 'Analyse - Cross Tabulation' page.
Right click on add a question to a row (highlighted in red).
This is for creating your side break.
Clicking on 'Add question' will open a question selector pop up.
The pop-up will have four tabs: Survey, Sample, System and Calculated.
- Survey: This section shows all the variables which are created as questions while creating the survey in the Designer section.
- Sample: This section shows the sample variables containing respondents information like Email, Phone, Name, Location etc. to whom the survey has been sent for data collection. These variables are created in the Distribution section while creating a distribution list.
- System: This section shows the list of automatic system generated variables while the data is collected. These variables are created in DTS (Data Transformation service).
- Calculated: This section contains the list of all the calculated variables if any while collecting the data or uploading a data file.
For our example, we will select the following 2 questions. One is a simple grid and the other is a single choice question. See snapshot of the questions below.
Both the questions will be selected from the Survey tab. But before we go ahead and select the question, you should be aware of some cool features available once the Question selector pops up, like
- Before adding the question, you can check the frequency of a question's options/items, by simply clicking on the question. The right pane shows the frequency for all the options.
- There is a small arrow adjacent to the question. Clicking on it will open the variables of the question. If there are more than one variable in a question then it shows all the variables and user can choose any amongst them. For example, for a grid question, it will show all the attributes of the grid as separate variables/questions. Since the example below is a single choice question, it shows only one variable.
Below is the snapshot of a grid question, (highlighted in red). It shows all the attributes after opening the arrow and user can select any one of them. This gives the user the flexibility to create his analysis using only a single attribute of a grid, or adding all the attributes of the grid.
Now coming back to our example of adding the side break, click on Q3 in the left pane and click on 'select' (highlighted in red).
Clicking on select will run the analysis and add the single choice question to row (highlighted in red) showing the col% by default.
The next step is to add a top break. Click on "right click here to add a question" and click on Add question (highlighted in red).
This will open the question selector where we will select the grid question Q9. In this case, we are selecting and adding the grid question, and not its separate variables. So all the attributes will be added in the cross tab.
Clicking on select will run the analysis and add the grid question to column (highlighted in red).
Adding Multiple Questions
You can now use some advanced options to customize your crosstab like add multiple questions is a row or column.
To add multiple questions, right click on the question text that is already added, This will open a drop down with one of the option as 'Add question' (highlighted in red). Click on Add Question. This will again open the question selector and user can then add multiple questions.
After selecting the question, the analysis will look like as shown below and the same procedure can be done to add multiple questions in a column.
Adding Nesting in row or column:
Right click on the question text that is already added. This will open a drop down with one of the option as 'Nest question' (highlighted in red). Click on Nest Question. This will again open the question selector and user can then add a nested question.
After selecting the question, the analysis will look like as shown below and the same procedure can be done to add nesting in a row.
Delete a Question:
Right click on the question text i.e. highlighted in blue and underlined will open a drop down with one of the options as 'Delete question'. Click will delete that question. If a user wants to delete a nested question he can click on that question text and it will be deleted. If a user clicks on the question text added in a row or column then clicking on delete will delete the whole question.
Adding a Calculated Row or Column:
In order to create the calculated row or column user needs to first select the cells (highlight in red)
Clicking will highlight the whole column and then user can right click will open a drop down where 'create calculate column' will get highlight and all the other options gets greyed out.
Clicking will open a 'create a calculated column' pop up'.
User can create the column name and can write different expressions e.g. C4 + C5.
Clicking on save will create the calculated column in the analysis.
Delete a calculated row or column:
In order to delete the calculated row or column user needs to first select the cells of the calculated row or column is created.
Right Click will show the option 'delete calculate column' and clicking will delete the same.
Click Here to know more about what can be done in properties.