x

Tables

Reporting

Step-by-Step

You can add tables to display a variety of information, including response frequencies, statistics, text analysis, and cross tabulations.

Add a table
  1. Click New Table. For more control over its placement, drag the New Table button directly onto your report.
  2. 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.
Choose a Data Source
You can change the data source for a table at any time, or you can use multiple data sources.

To Change or Add a Data Source

  1. Click Data Source.
  2. Click Survey or Question to change which survey or question the data is coming from.
  3. Click the plus sign to add another data source.
  4. Click the minus sign to remove a data source.
Change 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.
Set 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.
Change 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.

More Information

Qtips
  • 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.