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

Tables Basic Overview (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 Tables

Tables can be an orderly and clear way to summarize results in your subject report.

Click New Table on the top-left to add a new table to your report.

New Table option within a subject report

Table Types

You can choose your table type in one of two ways:

  1. Click on an existing table and then click Table Type on the toolbar above.
    Selecting your table type from the top navigation bar in the subject report
  2. When you create a new table, click the Table Type dropdown.
    Selecting your table type from within the visualization in the subject report

Once you’ve opened the list of table types, you will see the following options. Click on a link to learn more about that specific table.

Header and Column Options

When you hover over the header in a table, a dropdown arrow will appear that allows you to edit settings for the header or column.

Header and column options within a table

  • Font: Determine the font face, font color, and font size of the header
  • Cell Alignment: Choose whether the text in the header is left-justified, right-justified, or centered.
  • Rename: This option is only available when editing the header. Change the header text.

Column Options

  • Font: Determine the font face, font color, and font size of the column.
  • Cell Alignment: Choose whether the text in the column is left-justified, right-justified, or centered.
  • Conditional Cell Formatting: Create conditions where the background color, font color, font size, and font bolding of the cells in your column can change!
    Example: In the image below, scores of 4 and above have a blue background, and scores below 4 have a grey background.

Fonts and Table Styles

When you right-click on table and click Table Options, or you click on a table and then choose Table Options from the toolbar, you will have a Font option. Here you can change the font face, size, and color for your table.

Fonts and style options within a table

Just below the font options, you’ll notice a series of premade table styles to choose from. Click on one of these to change the look of your columns and rows.

Table Options

You can access Table Options by right-clicking on a table, or by clicking on the table and then the Table Options button in the toolbar above.

Available Table Options in a subject report

Some table options are exclusive to a type of table.

Decimal Places

Determine the number of decimal places displayed for each number in your table.

Transpose

Select Transpose to switch the rows and columns. For example, here is a Statistics Table without being transposed:

Example statistics table that is not transposed

And here is the same table, transposed:

Example statistics table that is transposed

Qtip: If you need to show/hide columns and rows, you’ll notice that even when the table is transposed, the old settings apply. So for the second image, if you want to hide the Min Value column, you’d navigate to Show/Hide Rows.

Sort By

Choose a component to sort the table by. For example, if you choose to sort by the “Leadership” scoring category, higher Leadership values will be at the top of the table, in descending order.

Row Limit

Determine the maximum number of rows your table can have. Choose None to let all the data fit the table, or choose a number from 1-10.

When you choose None, your table will not automatically break into multiple pages to accommodate lots of data. If you’re worried about your data running over, please check out the Split Table Settings section, or read about Automatically Create Pages for Additional Rows below.

Qtip: The table does not count headers when it counts rows.

Show/Hide Columns/Rows

When you select Show/Hide Rows, you can determine what rows of your table to display or hide. When you select Show/Hide Columns, you can determine what columns of your table to display or hide. Items that are shown are indicated by checkmarks next to their names.

Show/Hide Columns/Rows option within the Table Options dropdown menu

This setting is helpful if there’s certain data you don’t want to include. For example, if you want your Statistics Table to only display the mean, minimum, and maximum values, you can hide the Variance, Standard Deviation, and Total Responses and Respondents.

Uniform Cells

When you select Uniform Cells, the cells in your table become the same height and width as each other. This setting is helpful if the text inside the cells is about the same size, and do not contain any particularly long statements.

Example of table with uniform cells option applied

When you deselect Uniform Cells, the cell tries to fits as best it can around the length of the text inside. Note in the table below how the “Loyal to the Company” column elongates.

Example of table with uniform cells option not applied

Expand to Height

When selected, Expand to Height fits the table to whatever space you’ve stretched it to.

If you deselect Expand to Height, the table will take up the minimum of the space it needs to get the information across.

Example of table with the expand to height option not applied

Clear Properties

If you’ve made changes to the rows or columns that are displayed, changed the font, or made any other customizable changes to your table, you can remove them by clicking Clear Properties. This option is not reversible!

Split Table Settings

Sometimes, you may collect hundreds or thousands of open-ended feedback from your participants. Or you may create a table with tons of data sources, expanding the number of rows it contains. If you have so much data it runs off the page, you can use Split Table Settings to shorten the table or split it into multiple pages.

If you want to split your table into multiple pages and not just shorten it, you first need to create multiple copies of the same table.

You can create multiples of the same table one of two ways:

Copy page option in a subject report

  1. Copy the whole page.
  2. Click New Table on the toolbar and rebuild the copies from scratch.

Then navigate to Table Options and select Split Table Settings to get started.

Selecting the Split Table Settings option within the Table Options dropdown settings

You have two options for splitting a table: Split the table up into pages and Choose a start row.

Split the table up in pages

This setting is better if you want split tables to have a uniform number of rows on each version.

Split Table Settings pop up window

  1. Select Split table up into pages.
  2. Decide on the number of rows you want to display on each page of the table.
  3. Once you’ve determined Rows per Page, the Split Table Settings will now create separate pages for your table. Select from the dropdown which page you want to display on your table.
  4. When finished, click Save.

For example, you might have three pages of the same table. Under the Split Table Settings, you would assign them Page 1, Page 2, and Page 3, separately.

Choose a start row

This setting is better if you’re looking to start on a special row, or customize what data range appears in each copy of the table.

Specifying a a start row in the split table settings window

  1. Select Choose a start row.
  2. Determine your Start Row.
  3. Choose how many rows to display.

With this setting, you would arrange your table copies to pick up where the others left off. For example, if your first table shows rows 0 to 15, your next table would show 16 to whatever higher range you prefer.

Headers count as rows, but if two are next to each other, they count together. For example, in this screenshot, 6 rows display on the table in the background.

6 rows displayed in a table

In this screenshot, headers are excluded because we start on 1 instead of 0, so the table shows exactly 5 rows, as specified.

5 rows displayed with no header

Automatically Create Pages for Additional Rows

When you have too much data to fit into your table, you can make the table create additional pages automatically to accommodate this. This option serves as an alternative to Split Table Settings.

Qtip: Additional pages created with this setting only appear when you export reports from the Participants tab! If you export reports from the Reports tab, the new pages will not appear.
  1. Open Table Options.
    Automatically create pages for additional rows option within the table options dropdown menu
  2. Click Automatically Create Pages for Additional Rows.
  3. Select Expand To Additional Pages.
    Expand to additional pages options
  4. Fill out the maximum number of pages that can be created automatically. The maximum is 100.
    Qtip: This setting does not mean that 100 pages will be created. It also does not mean that only 100 responses will be included. It means that if there were thousands of possible rows, they’d take up a maximum of 100 pages before they stopped generating.
  5. Select the Templates to Use when the page is generated.
    Qtip: Check out the Templates section of the Reports Pages guide to learn more about templates.

FAQs