CrossTab


By using CrossTab, relationships in data can be analyzed as well as understanding interactions between variables. Dapresy Pro CrossTab report allows can be used 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 "Add new report"  button or dropdown to select Cross Table tool.
  • Assign the name for the newly created report and Save.
  • Go to Design/Preview reports and look for the CrossTab report recently created.




Rows and Columns


To start with CrossTab, variables need to be drag and dropped into Rows, Columns or filters. In the Rows, Columns and Filters tab, choose which variables to use as “Questions” and as “Splits” as well as their order of the items. The layout is very flexible and the splits can be nested in multiple levels or shown side by side. Questions and Splits can also be positioned, in rows or in columns. Below, it is seen 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 the report adding questions and changing settings for the CrossTab is the next step.



Step by step

1.   Select the questions that should be viewed, by drag and dropping from the left-hand side of the Cross Table tool  

2.   Add the Splits by dragging to "Columns" field.

3.   Choose if splits will be nested or not. The splits are nested as default.


NOTE: For multiple selections use CTRL + Click or SHIFT + Click






4. Add questions to Rows.

5. Press Generate button to run the cross tabulation for the selected variables.

6. Use the “Full screen” mode button when working with big tables.

7. The table can also be downloaded into Excel from this tab by clicking the “Export to Excel”.






Notes:

  • One question at the time can be select 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 “nesting” behavior can be defined. The selected splits will either be nested or shown side by side.



Additional Options

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. Sort order of the questions can also be changed within the question group by drag & drop.



Step by step

1. Select the questions that are needed by clicking the “Add as question” button (or Drag and Drop).

2. Hover over added question to enable moving the question box to split.

3.Press Transpose in case the content needs to completely swap between 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.



Note: Whole question block can be added using Drag and Drop method.




Limit the Answers of the selected Questions and Splits


If the answers in the questions and splits will be limited, then 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.





Adding Table Brakes.


In order to add table brakes right click to access the context menu as seen below.


1. Select "Insert table brakes after every question" 

2. Click the X (remove) button on individual brake line.



Now tables will be separated as per desired outcomes. 




Alternatively, Right clicking on the question brings out the context menu where individual brakes can be added by insertion before or after the said question. 


Note: To remove all table brakes use an option form the context menu as before


Rename Sheets


The sheet name is displayed at the top of the “Rows, Columns and Filter” tab, by clicking the text it is possible to edit the sheet name. This name is applied when the sheet is exported to Excel. In order to be able to edit the sheet names, "Allow saving workbooks" option in the setup menu must be enabled.





Excel Export of workbook with table breaks


When exporting a workbook with table breaks to Excel the following export options are available: 


• Export all sheets as separate Excel sheets. 

• Export all tables as separate Excel sheets. 

• Export all sheets into one single Excel worksheet. 


Note: "Export all tables as separate Excel sheets" (second option) is only applicable when table breaks have been used. 


When exporting as “Export all tables as separate Excel sheets” all the tables from every sheet will be exported as separate sheets.


Example: with a workbook containing 3 sheets; 1st sheet contains 4 tables the 2nd sheet 5 tables and 3rd sheet 2 tables. In this case, exported Excel file contains 4+5+2= 11 worksheets.



Add Split Dropzone


The split dropzone is located in columns by default, for advanced table creation enable additional split dropzone by ticking the “Show all split dropzones” option in the Split setting menu.





Add Totals and Subtotals Splits


Totals and Subtotals Splits can be added to a 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 there are 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 as well.







The image below shows a table with Splits in both columns and rows, so demonstrating 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 there will be 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 seen below 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.