<Add introduction for aggregate functions>

Creating a count-based query

<How to add aggregate functions>

<List down all the aggregate functions available>

<For each function add an example with expand macro>

<How to remove the aggregate function>

Examples:

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

2 : Find sum of available aliquot qty per parent specimen

3 : Find the latest transfer event for every specimen.

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

Applying filters on aggregate values

Explanation: Let's say, for the above query example1, 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>

Summary reports

Pivot Table

Column Summary

Limit Specimens by cumulative quantities

...

<List down all the fields and its functions>

...