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

To open the Table View, click Open beside a data table, a results table, or a saved interpretation.

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 ALL  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. 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 drop-down 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. Click the header of the column you want to format and in the dialog box select Options.
2. 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.

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

   When you save, 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 an operator 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 10²¹.

   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.
   • Click More Actions and select Save As.

   When you save, 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.