You can add tables to display a variety of information, including response frequencies, statistics, text analysis, and cross tabulations.
Adding a Table
- Click New Table. For more control over its placement, drag the New Table button directly onto your report.
- If Qualtrics prompts you for a data source, click the Select Data Source or Select Item drop-down to specify where the table data should come from.
Changing the Table Type
A variety of table types are available, depending on the type of data being displayed. Click Table Type to select a different type.
The following table options are available:
- Default: This table shows the choices, the number of responses, and the percent of responses for each choice.
- Statistics: This table shows basic statistics, including Min Value, Max Value, Mean, Variance, Standard Deviation, and Number of Respondents. Optionally, you can add a Top Box and Bottom Box, and a Net Promoter Score (NPS) will automatically be calculated.
- Table Other Text: This shows the entered text for a text box appended to a non-text answer choice (for example, a text box on an “Other” choice).
- Text Analysis: This displays a table of the top ten words used and the count of their usage. Clicking View More will display a comprehensive list, which can be exported to Excel.
- Cross Tab: If you have created a cross tab in the Cross Tabulation area of the tool, you can select it here and display it in your report. You can also create a new cross tabulation from here.
Setting the Table Options
Click Table Options to access the following features:
- Font: Change the font style, size, and color.
- Look and Feel: Click a thumbnail to change the general appearance of the graph.
- Decimal Places: Choose how many decimal places are used when displaying values. Two is the default selection.
- Transpose: Reverse the columns and rows of the table.
- Sort By: Choose a column by which to sort the table.
- Row Limit: Specify how many rows of your table are displayed. This is useful for large tables that do not fit well on a single page. You can specify between one and ten rows. No limit is the default selection. Show/Hide Rows might be better to use if you want to spread the table across multiple pages of the report.
- Show/Hide Columns: Choose which columns to display in the table.
- Show/Hide Rows: Choose which rows to display in the table.
- Data Format: Base the table on the count, percent, or mean.
- Uniform Cells: Set each cell in the table to have equal width.
- Expand To Height: Space out the table rows to fill the entire space the table is allotted. This is selected by default.
- Export Table To: Export the table to PDF, Microsoft Excel, Microsoft Powerpoint, or Microsoft Word.
- Clear Properties: Revert to the default table settings.
Changing the Table Layout
Access basic settings for how the table appears on the page. The following options are available:
- Show On All Pages: Show the selected table on all pages of the report.
- Always On Top: Specify that the table always shows on top when it overlaps with other page items.
- Always On Bottom: Specify that the table always shows on bottom when it overlaps with other page items.
- Add Description: Automatically add the question text for the question the table represents. Double-click the text to edit as needed.
- Center Within Page Horizontal: Center the table horizontally on the page.
- Center Within Page Vertical: Center the table vertically on the page.
- Reapply Layout: After making changes, you can apply the original layout back to the table using this option.
- Remove Item: Removes the selected table from the page.
Tables also provide the ability to adjust the column headers. Click a table heading to edit Header Options or Column Options:
- Header Options: Adjust the font size, style or color, or rename the header.
- Column Options: Adjust the font size, style or color, and change the cell’s text alignment to left, center, or right.
- When working with multiple data sources, make sure the sources ask for the same type of information and have the same answer choices. If you’d like to make a comparative table, a cross tabulation would be more appropriate.
- If a table is too small to hold all of its data, it will display as a torn sheet of paper at the bottom. Simply resize to show all information.
- Right-clicking a table will bring up the same editing and layout options, plus the option to create a new drill-down report based upon the table’s data.