Using CrossTab, you can analyze the relationship in data and find interactions between variables. Dapresy Pro CrossTab report allows you to quickly add multiple questions, filter the answers to be shown, change sort order of the variables or use Correlation calculations.
How to add the Cross Table tool?
The setup is done in two steps. First, the Cross Table tool needs to be added as a portal tab from Admin pages. Secondly, the content of the Cross Table tool needs to be defined, e.g. which questions will be shown, which calculation types will be present. All questions, calculation types, settings, etc. are turned on by default, so the second setup step is optional. It only needs to be made if the content will be limited for the report users.
Step by step
- After logging into Dapresy, in Admin view, look for Portal design page.
- Use the Report Type dropdown to select Cross Table tool 2.0.
- Assign the name for your new report and Save.
- Go to Design/Preview reports and look for the CrossTab report you just created.
Rows and Columns
To start with your CrossTab, you need to select variables for Rows and Columns. In the Rows and Columns tab, you can select which variables to use as “Questions” and as “Splits” as well as the position of the items. The layout is very flexible and the splits can be nested in multiple levels or shown side by side. You can also select where the Questions and Splits should be positioned, in rows or in columns. Below, you can see how to select Questions and Splits, and how to use drag & drop to create the desired layout of the table.
Adding questions to rows and columns
After accessing Design/Preview mode and finding your report you can start with adding questions and changing settings for your CrossTab
Step by step
5. Hover over a question on the left-hand side of the Cross Table tool.
6. Select the questions you want to view the result for by clicking the “Add as question” button.
7. Select the Splits by clicking the “Add as Split” button.
8. Select if splits will be nested or not. The splits are nested as default.
9. Press Generate button to run the cross tabulation for variables you selected.
10. Use the “Full screen” mode button when working with big tables.
11. The table can also be downloaded into Excel from this tab by clicking the “Export to Excel”.
- You can either select one question at a time or hold Shift/CTRL to select multiple questions at the same time.
- The intervals and hierarchical filters cannot be used as questions, so the option “Add as question” is not shown for those; they can only be used as splits.
- Only categorical questions, intervals (week, month, etc.) and the hierarchical filter can be used as splits. Numerical questions cannot be used as splits.
- If multiple splits are positioned in columns (or in rows), then you can define the “nesting” behavior. The selected splits will either be nested or shown side by side.
Position the Questions
The questions can be positioned in either rows or columns. This is done by drag & drop. The sort order inside the question group can also be changed. The whole question group can be dragged and dropped to the column area. It can either be placed between the nested splits or below/above the splits. You can also change the sort order of the questions within the question group by drag & drop.
Step by step
1. Select the questions you want to view the result for by clicking the “Add as question” button.
2. Hover over added question to enable moving the question box to split.
3.Press Transpose if you want to completely swap content of question and split.
4. To remove a split or a question use the “Clear all” option in the top right corner (which appears when hovering over the “Clear All” button) or
5. Click the “Clear” icon that appears in the question and splits on hover over.
Limit the Answers of the selected Questions and Splits
If the answers in the questions and splits will be limited, then you need to hover over the desired Question/Split and click the “Select Answer” icon.
6. Then select the desired answers to be shown in the popup panel.
Due to the logic of answer blocks in Dapresy Pro, the questions (not the splits) which share the same answer blocks will always have the same answers selected. In the example below, all five questions are sharing 1 answer block. If the user selects to only show answers 4 and 5 in the question “Brand considerations – Dapresy telecom,” then the other 4 questions will show the same answer options. If some answers are selected in one of the questions, then the same answer selection will be applied to all five questions as they are sharing an answer block.
Add Totals and Subtotals Splits
You can also add Total and Subtotal Splits to your table; see details and the difference between the Total and a Subtotal below. The Total includes all respondents fulfilling the overall filters, and it is not being nested with any other Split. The Total appears in columns and/or rows if you have Splits in columns and/or rows. The image below shows an example of a Total in columns. By default, it appears in the last column, but it can be changed to the first column if you would like.
The image below shows a table with Splits in both columns and rows, so you can see the Total in the columns and in the rows.
The Subtotal is added as a column (or row) per selected Split. For example, if the two variables Gender and Age groups are shown as splits, then you will get one Subtotal for Age groups and another one for Gender. Each Subtotal is based on the respondents included in the shown options of the Split. If the Age group variable has five options but only two are shown in the table, then the Subtotal for the Age group variable will consist of all the respondents belonging to those two options.
The image below shows the same table as the one above, but the Subtotals are shown instead of the Total. As you can see, one Subtotal is generated for Age groups and another one for Gender.
The Total and the Subtotal can be used simultaneously, as shown in the example below. The table below is the same table as the one shown above, but both the Total and the Subtotals are shown.