<Add introduction for aggregate functions>

<List down all the aggregate functions available>

<For each function add an example with expand macro>

Creating a count-based query

Example: Summarize protocols by participant, visit, and specimen counts.

<How to add aggregate functions>

<For each function add an example with expand macro>

Creating a count-based query

<How to add aggregate functions>

<How to remove the aggregate function>

Example1: Summarize protocols by participant, visit, and specimen counts.

Example2: Find sum of available aliquot qty per parent specimen

Example3: Find the latest transfer event for every specimen.

Example4: Count of specimen, collected every quater per visit site.

Applying filters on aggregate values

Explanation: Let's say, for the above query exampleexample1, you need only those CPs that have more than ‘x’ no. of visits count.

...

<Steps to get expression of a field to include in aggregate filters>

Aggregate filters can be applied on aggregate functions. 

This can be done by going to 'Actions' → 'Columns' and going to the last step, 'Reporting Options'.

...

Summary reports

Pivot Table

Column Summary

Limit Specimens by cumulative quantities