<None Super Admin Limitaion while running aggreagte queries>
<Add introduction for aggregate functions>
Creating a count-based query
<How to add aggregate functions>
<List down all the aggregate functions available>
Based on the field selected, aggregate functions available differ. For numeric fields, functions like sum, avg etc. are available but for text fields only count is 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>