<None Super Admin Limitaion while running aggreagte queries>
<Add introduction for 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>
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 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>