Beginners Guide to Crosstab
This guide provides a comprehensive overview of Crosstab in DataTile, offering a step-by-step exploration of the interface and functionalities for first-time users. Let’s dive in.
The Crosstab Interface
The crosstab interface, also known as DVI, is the main screen for building tables in DataTile. The image below highlights some key areas of crosstab functionality that are essential for new users. Each of these areas will be explored in greater detail within this guide.
The Codebook
The codebook is a key element of crosstab as it contains all the variables (questions) in your database, in addition to all the essential information about them, such as name, data type, and/or question number. The codebook is always shown in the left-hand panel of the crosstab space.
We recommend that you organise the codebook in the Meta-Editor after uploading a new database to ensure ease of navigation and analysis. Click here to learn how.
Click on any variable to view its categories (options) and they will be shown in another panel. These are the key variable types you may come across:
To learn more about the different variable types click here.
Build your first crosstab
To build a table, drag and drop variables (questions) or options (answers) directly from the codebook onto the columns or rows of your table. To select more than one element you can hold down the CMD or CTRL keys.
As you can see in the video above, when you drop a variable onto the grid or table you are presented with various options which tell the software how you want your data to be inserted. Once you have selected the right option, click CALCULATE to view the data.
The most commonly used options are:
As List - Insert the categories in a list format
OR-Join - Group together people who answered ‘yes’ to any of the selected answers.
For example, if you input the age categories ‘30-39’ and '40-49, anyone who answered yes to either of these will be included.
AND-Join - Group together people who answered ‘yes’ to both of the selected answers.
For example, if you input ‘Men' and ‘30-39’, anyone who answered yes to both of these will be included.
AND-Join as group - This should be used when you select more than one code to join an existing code (e.g. variables already in the table). The selected codes are OR’d together within brackets, before being AND’ed with the existing variables.
For example, imagine you already have the ‘Men' variable in the rows of your table. If you select the age categories ‘30-39’ and ‘40-49’, and select And-Join as Group, the resulting variable would be ‘Men’ who are either ‘30-39’ OR ‘40-49’. In logical terms, it would be expressed as “Men AND (30-39 OR 40-49).
Delete columns or rows ( the 'x-box')
To view different actions for the table hover your mouse over the ‘x-box’. You can delete selected columns, rows, both, or transpose your columns and rows.
Dynamic Filter Toolbar
The Dynamic Filter toolbar is another space where you can drop variables onto, adding a third element or base to your analysis.
Filter - This acts as a base, letting you to narrow down the data based on specific criteria, such as a particular audience or wave of data. The default is all.
Split - This acts as a sub-base where you can add another dimension to your table. For example, if you drop the Regions onto the Split bar, you can toggle between each region and analyse the data simultaneously without needing to redo the table each time. Export to excel will report each split.
Metrics and Analysis Toolbar
The Metrics toolbar contains various other features which can aid the analysis of your data. The different buttons that appear here are determined by the databases settings. Click here to learn more.
Vertical % is the default metric used in crosstab, to view other options click the ‘Metrics’ button.
Save or share your crosstab
In the top-right toolbar you can find three icons that help you to save or to share your crosstab.
First of all, you can export the table to a dashboard, using ‘Export to dashboard' icon.
Secondly, you can provide a quick access to your crosstab for collegues (who also have access to DataTile and database) using a shortcut link. You get the link by clicking on the ‘Shortcut’ icon.
And finally, you can download the table to PowerPoint, PDF, Excel, or as a PNG or JPEG image. Click on the ‘Download as’ icon and select the option from the submenu.
Additional Information
The Crosstab HUB
The Crosstab hub has three different modes of analysis; Crosstab, Grid Request, and Raw Data.
Crosstab is the default mode of analysis, and is characterised by building tables that show you how your variables interact, and provide information about how subgroups responded to your survey.
Grid Request mode empowers you to perform side-by-side analysis of different answers to the same question, such as a likert scale question. Click here to learn more.
Raw Data mode enables you to analyse open-ended text questions. Click here to learn more.
Tab management
In DataTile you can save and work on multiple crosstab runs at once. The tabs feature is useful if you want to analyse multiple runs simultaneously, refer back to previous calculations, or just to save and view them later.
Create a new tab by clicking the ‘+' icon in the left corner of the tab management toolbar. To view and open your other tabs, click the hamburger icon '☰’.
On the right-hand side of the toolbar, click the 'clone' icon to duplicate your current tab, or click 'X' to delete your current tab.
Tabs are automatically named based on the information in your crosstab, however you can rename them by double-clicking on the header.