Viewing table data

Use the Table View to display table data. In the Table View, you can re-order, sort, filter, format, and export data.

Open the table view

  1. Open the Results app.
  2. Open the collection that contains the table you want to open.
  3. For the table you want to open:
    1. To open the default interpretation, click the table you want to open.
    2. If that table has other interpretations, click the number in the Interpretations column, then click the interpretation you want to open.

Reorder or hide columns

  1. On the right-hand side of the page, click  Configure.
  2. In the Configure Table View panel, do any of the following and click Apply:
    • To hide all fields, switch off the Enable all fields  toggle. 
    • To hide a single field, switch off the toggle  next to the field name.
    • To display a single field, switch on the toggle  next to the field name.
    • To reorder columns, click and drag the field name up or down to the new position.
      The order in list matches the order in the Table View.

    3. Tip

    You can enter a keyword or phrase into the Search field to filter the list of available columns.

  3. Click  to close the Configure Table View panel.

Sort column data

  1. Do one of the following:
    • Click the header of the column you want to sort.
      Tip

      If you only want to sort data, this method is quickest.

    • Click the filter icon  to open the View & Add Filters side panel.
      ​If you want to create nested filters in addition to sorting data, you need to use this method.
  2. If you are sorting using a column header, click the Ascending or Descending toggle button. 
    The data in the Table View is sorted.
    To remove the sort, click the column header and depending on which type of sort you applied, click the Ascending or Descending toggle button again.
    You can also switch the sort order. If you save the interpretation, the sort order is saved.
  3. If you are sorting using the View & Add Filters panel, do the following:
    1. Click the arrow in front of Sort by Column.
    2. Click Select field and select a field from the dropdown list.
    3. Click Normal order A>Z (Ascending) or Reverse order Z-A (Descending). 
      The data in the Table View is sorted. To remove the sort, click Remove sort .
      You can also switch the sort order, or select a different column to sort by.
      You can leave the View & Add Filters panel open, or click  in the title bar to close the panel.
      If you save the interpretation, the sort order is saved.

Format column data

  1. Open the Results app.
  2. Navigate to the appropriate table.
  3. Click the header of the column you want to format and in the dialog box select Options.
  4. From the list of display format options, select the format you want to apply to the data in the column.

    Result The window closes and the formatting is applied to the table.

  5. To save the interpretation, on the right-hand side of the page, do one of the following:
    • Click Save > Save.
    • Click Save > Save As.

    When you click Save As, you can edit the title and optionally enter a summary for the visualization.

For more information about formatting column data, see Data formatting options.

Apply conditional formatting to a column

  1. Click the header of the column you want to format and in the dialog box select Format > Options > Conditional formatting.
  2. To define the condition, click Add another condition and do the following:
    1. From the Select condition list, select a conditional operator.
    2. Enter a value to test against the conditional operator.

      Any positive number you input cannot be smaller than 10-5 or larger than 1021.

    3. Select an icon and icon color or select to disable the icon.
    4. Select a text color or click the toggle to disable text formatting.
    5. Select a background color or click the toggle to disable background formatting.
    6. Optional. To define another condition, click Add another condition and repeat steps a to e.

      Note

      If a field evaluates to true for more than one condition, the first defined condition takes precedence and that formatting is applied.

  3. To save the interpretation, on the right-hand side of the page, do one of the following:
    • Click Save > Save.
    • Click Save > Save As.

    When you click Save As, you can edit the title and optionally enter a summary for the visualization.

  4. Optional. To change or remove the formatting applied to a column, click the column header, in the dialog box select Options > Conditional formatting, and then update or delete the condition.

View column-level overview data

  1. For any column in the table, click on the column header.
  2. Click Data Distribution.

Result The data in the overview is different depending on the column's data type. However, expect to see things like:

  • a histogram of the data
  • high, low, and average values
  • standard deviation
  • totals
  • blank values count
  • unique values count
  • number of positives
  • number of negatives

When you apply filters to the column, the overview data updates to reflect the new subset of data in the column.

Tip

Click the column-level histogram to convert the histogram into a new bar chart visualization.

Adjust column widths

  • To adjust a column's width, click and drag the border on the right side of that column's header.
  • To adjust a column's width according to its data, double-click on the border on the right side of that column's header.
  • To adjust the width of multiple columns in one go, perform the following steps:
    1. Shift + click or Ctrl + click the column headers you want to adjust.
    2. Double-click the border on the right side of one of the selected columns' header.

Note

Refresh the page if you want to remove any extra space from the column header that may appear after adjusting and readjusting the column width. This extra space may appear If your column header contains long, free-form text like questions.

Wrap column text

If your table contains long, free-form text like questionnaire responses, you can force that data to wrap to make it more readable. Wrapping text will not break up long words like email addresses or URLs.

  1. Click the header of the column you want to wrap.
  2. From the dialog box, switch on the Wrap text toggle .

Result The data wraps to the next line when it reaches the edge of the column. If you adjust the columns width, the text will continue wrapping based on the new column width.