About Data Tables
The Data Table visualization allows you to view basic information about a selected metric for a given data source. By default, it displays the name of each answer option and the metric for each option. For example, if you set the metric to Choice Count, the number of respondents who selected each choice will appear to the right of each choice.
For basic visualization instructions and customization, visit the Visualizations Overview support page. Continue reading for visualization-specific customization.
Field Labels & Sorting
- Field: Adds a label to the first column in your table.
- Sort: Determines how the table sorts your data. Your options include:
- Default: The table’s default sorting.
- Custom: Allows you to determine the table’s sorting by choosing which order to present your data. You can change your custom sorting by dragging and dropping your column and row values in the editing window. See Column & Row Values below for more information.
- Label: Sorts by your metric labels in ascending or descending alphabetic order.
- Value: Sorts by your data values in ascending or descending order.
Column & Row Values
- Enable the Show metric type in default labels to automatically add the metric type to the table’s column labels.
- Type in the field to rename the value. This does not affect the question as it appears in the survey, just the visualization.
- Click and drag to change the order of the columns and rows.
- Deselect the checkbox to hide the value from the visualization.
Table Totals, Show Percentages, & Total Counts
Table Totals allow you to calculate and display the total sum of each row or column in a Data Table visualization.
- Show Totals: Decide between totals being displayed for rows or columns, or turn off totals altogether.
- Show Percentages: Decide if you would like to display percentages next to each value in a data table.
- Total Counts: This option is useful if you are reporting on a multiple select-style question, where respondents can choose multiple answers.
- Choice Totals: Base data on the number of choices. This can add up to more than the number of respondents because respondents can choose multiple answers for one question.
- Respondent Totals: Base data on the number of respondents. This will only ever add up to the number of respondents who answered the question. If the respondent skipped a question, then this number may be less than the number of completed responses you’ve received.
Select the Styles tab to modify table header and body fonts, as well as other visual aspects of your table.
- Determine the font, size, and color of the table’s Response Count.
- Determine the font, size, and color of the Table Header.
- Determine the font, size, and color of the Table Body.
- Select Alternate Row Colors to shade every other row and make them easier to read.
- Select Repeat Table Header will make sure that the header row (not the title) will repeat as the table gets much larger and has many rows.
- Use Table Density to choose how spaced out or compact your table is.
- Use Margin to adjust the table’s margins.
Data Table visualizations are compatible with almost every kind of variable in Qualtrics because they can display both discrete data (for example, a finite, five point scale) and continuous data (for example, a question where respondents type in their age). This includes most question types, survey metadata, embedded data, scoring categories, and custom variables, such as Formulas or Bucketed variables.
Below are the few variables Data Table visualizations are not compatible with:
- Text Entry question (without numeric content validation)
- Filter Only Embedded Data
- Text Embedded Data
- Text manual variables
In general, Data Table visualizations are incompatible with open text content that does not come in numeric format.