Comparison Tables

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

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: 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.

You can save a Comparison Table as a Microsoft Excel file, allowing the full range of Excel analytical and visualization functionality to be used to explore the data.

To create a Comparison Table report:

Choose the records of interest by adding them to the Record List.
On the Reports page, click Comparison Table.
Optional: Where report templates have been set up, you can select a template from the Use a report template list: this will add a predefined set of Attributes to the table.
To select the Attributes you want in the table, type an Attribute name in the text field.

Tip: Alternatively click Browse Attributes and select the Attributes you want from the browse tree.
Optional: To include record properties in the Comparison Table, select the relevant check boxes.
Optional: Under Options:
- Specify whether or not you want to include empty (unpopulated) Attributes in the comparison table. By default, they are not included.
- Specify whether or not you want to include statistical data in the table by selecting an option from the Summary statistics list, and specify how you want to handle zero values for the statistical summaries.
To view the report on screen, click View This Report.
On the Comparison Table Report page, you can review the data and remove any columns or records you do not want. You can also modify Functional data parameters, and change the units used for numerical data.

The following options are available to change your Comparison Table:

Option	Description
Remove Record	Click the X next to the name of a record or column to remove it from the report.
Transpose Table	Switch the columns and rows in the report.
Change parameters	Modify the parameters for functional data in the table
Units	Change the units used in the table
Modify Report	Add Attributes or record properties to the report, or change the report options

Check the data, and modify the report, as required. To view a printable version of the table: in the menu bar at the top of the page, click View > Printable Report and then print it using your browser's Print function.