<None Super Admin Limitaion while running aggreagte queries>
<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>
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.
<How to remove the aggregate function>
Applying filters on aggregate values
Explanation: Let's say, for the above query example, 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'.