| Child pages (Children Display) | ||
|---|---|---|
|
| Note |
|---|
<None Super Admin Limitaion while running aggreagte queries> |
<Add introduction for aggregate functions>
Creating a count-based query
<How to add aggregate functions>
...
<How to remove the aggregate function>
Examples:
1 : Summarize protocols by participant, visit, and specimen counts.
...
| Expand | ||
|---|---|---|
| ||
<Details> <Screenshots> |
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
| Expand | ||
|---|---|---|
| ||
<List down all the fields and its functions> Example: |
Column Summary
| Expand | ||
|---|---|---|
| ||
<List down all the fields and its functions> Example: |
Limit Specimens by cumulative quantities
| Expand | ||
|---|---|---|
| ||
<List down all the fields and its functions> Example: |