| Note |
|---|
<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>
| Info |
|---|
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.
...
| Child pages (Children Display) | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|