Comparison Tables

Use Comparison Table reports to see a side-by-side comparison of data in selected records.

Video: How to create Comparison Table reports [2:08]

As well as data values and record properties, Comparison Tables can include the following.

  • Statistical summary data. The mean, median, standard deviation (of a sample), minimum and maximum value are calculated for numeric Attributes. The number of values used in the calculation for an Attribute is also shown (Count).
  • Quality Ratings. Where quality ratings are available for the data, they can be included in the report, and you can set the quality rating threshold. Note that changing the value of the threshold on the Comparison Table Report page changes the application default for the database throughout the application.
  • Curves. For records that include functional data Attributes, graph data is shown below the table. You can modify the parameter values by clicking Tools > Change parameters at the top of the page.
  • Local and linked Tabular data. Because linked Tabular data is typically too complex to be displayed on screen, you will need to create a Comparison Table Excel report to view it.
  • Release date. For records in version-controlled Tables, the date the record was released can be included in the report. For example:

You can save a Comparison Table as an Excel (XLXS) format report, allowing the full range of Excel analytical and visualization functionality to be used to explore the data.