Loading...
  • Customer Experience
    Customer Experience
  • Employee Experience
    Employee Experience
  • Brand Experience
    Brand Experience
  • Product Experience
    Product Experience
  • Core XM
    Core XM
  • Design XM
    Design XM

Data Table Visualization (360)

What's on This Page:


Was this helpful?


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The feedback you submit here is used only to help improve this page.

That’s great! Thank you for your feedback!

Thank you for your feedback!


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.

a data table visualization in a 360 report

Qtip: Don’t like your table colors or fonts? Head over to the report settings to change them for the whole report!

Customization

For basic visualization instructions and customization, visit the Visualizations Overview support page. Continue reading for visualization-specific customization.

Field Labels & Sorting

the field and sorting options in a data table visualization

  1. Field: Adds a label to the first column in your table.
  2. 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.
    Qtip: You can quickly reverse the order of your sorting by clicking the arrow next to the sorting option.
    the arrow next to the sorting option for reversing the sorting order

Column & Row Values

the column and row options in a data table visualization

  1. Enable the Show metric type in default labels to automatically add the metric type to the table’s column labels.
    Example: For example, if your metric is set to “Choice Count,” then “Choice Count” will be added to your column labels.
    a data table with metric labels added to the columns
  2. Type in the field to rename the value. This does not affect the question as it appears in the survey, just the visualization.
  3. Click and drag to change the order of the columns and rows.
  4. Deselect the checkbox to hide the value from the visualization.

Table Totals, Show Percentages, & Total Counts

the table total options in a data table visualization

Table Totals allow you to calculate and display the total sum of each row or column in a Data Table visualization.

  1. Show Totals: Decide between totals being displayed for rows or columns, or turn off totals altogether.
  2. Show Percentages: Decide if you would like to display percentages next to each value in a data table.
    a data table with percentages added to the table
  3. 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.

Styles

Select the Styles tab to modify table header and body fonts, as well as other visual aspects of your table.

the style tab when editing a data table visualization

  1. Determine the font, size, and color of the table’s Response Count.
  2. Determine the font, size, and color of the Table Header.
  3. Determine the font, size, and color of the Table Body.
  4. Select Alternate Row Colors to shade every other row and make them easier to read.
  5. 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.
  6. Use Table Density to choose how spaced out or compact your table is.
  7. Use Margin to adjust the table’s margins.

Incompatible Fields

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:

In general, Data Table visualizations are incompatible with open text content that does not come in numeric format.

Qtip: Be careful with numeric data collected from open-ended questions and with finite scales that have hundreds of choices. A Data Table visualization cannot comfortably display hundreds of choices!