Use a Category Aggregator to compare different samples

This example describes how to compare the average peak areas for two different sets of samples. In contrast to the other example (see Use an Aggregator), the information is now prepared and shown separately for each compound.

To create the variables:

1. Add the Compound Results table to the template twice.

2. Repeat both tables on Compound_Name.

3. Filter the tables according to the samples for which you want to obtain the average peak areas.

4. In each table: Open the Column Properties dialog of the Area column, and save the value as a variable. Use the following settings:

   • Calculation Variables: Aggregator

   • Calculation Variable Name: For example, AreaAggregator1 in the first table, and AreaAggregator2 in the second table.

   • Category: Compound_Name

   • Condition: [None]

For the Category setting, you must use the same value as in the Repeat On setting for the tables.

To use the variables:

1. Underneath the tables, add two text fields to the template:

   • The first text field shows some static text and the compound name:

     ="Difference between average areas for" + Compound_Name

   • The second text field shows the calculated value:

     =Avg(AreaAggregator1(Compound_Name)) - Avg(AreaAggregator2(Compound_Name))

2. Select the two fields and create a composite group.

3. Repeat the composite group on Compound_Name.

After a number of tables, the generated template will show the text fields for each single compound.