Create an Aggregator based on a concatented index

This examples describes how to create a table with average amounts per sample and compound, with the average shown in a separate column.

In this example, you prepare an Aggregator in a hidden first table, and show the results in a second table.

Note that this example is supposed to work in a Single sequence summary template.

Prepare an Aggregator

1. Add the Compound Results table to the template, and make it invisible.

2. Open the column properties of the Amount column, and edit the value.

3. Save the expression as an Aggregator, for example, with the name AG1.

   Under Category, select <Expression...>, enter the following expression:

   =Sample_Name + CompoundName

   

Show Aggregator content

1. Add another Compound Results table to the template. Add a Sample name column, and remove all other columns except Name and Amount.

2. Use the following expression for the value of the Amount column:

   =Avg(AG1(Sample_Name+Compound_Name))

3. Select Hide Duplicates for the Amount column.

4. Change the header text for the Amount column to Amount (Mean).

5. Adjust the sorting as required. For example, sort by Sample_AcquisitionOrderNo.