Formatting data display in a comparison table

You can change the way that data is displayed using the toolbar at the top of the Comparison Table window.

Choose how many data properties to show in the table:
  • To show all available data properties (excluding text and functional data properties, but including any calculated properties), click the All Data button.
  • To show only the properties that are used in the current selection project, click the Project Data button (this option is only available if a selection project is open).
Choose how data stored as a range is displayed:
  • To show range data as a range (maximum and minimum value), click the Ranges button.
  • To show range data as an average value, click the Averages button.
Choose how numerical data values are displayed relative to the reference record:
  • To show numerical data values as absolute values, click the Values button.
  • To show numerical data values as a percentage change relative to the reference record, click the Percent Change button (this option is only available if a reference record has been set).

Set the threshold for highlighting differences relative to the reference record:

When a reference record has been set for a comparison table, any numerical data values that differ from the reference record value by more than a specified percentage are highlighted. You can specify this percentage threshold in the toolbar at the top of the Comparison Table window.

In the toolbar at the top of the Comparison Table window:

  • Type a percentage into the Highlight % Change box
  • Click the Apply button.

    The comparison table is updated to show the new threshold.

    Note:
    • For non-numerical data values (such as discrete or logical values), all values that differ from the reference record are highlighted.
    • For numerical data values, differences greater than the threshold percentage are highlighted regardless of whether the numerical data values are shown in the table as percentages or absolute values.
    • The percentage change for each data value (V) is calculated as a percentage of the reference record value (VR) as (V-VR)/VR
    • For range data, (V-VR) is calculated as the minimum difference between the end-points of the two range values (the difference between the upper bound of the smaller range value and the lower bound of the larger range value)
    • Data values for the reference record are shown as absolute values