Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

<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.

 Expand...

<Details>

<Screenshots>

Example2: Find sum of available aliquot qty per parent specimen

 Expand...

<Details>

<Screenshots>

Example3: Find the latest transfer event for every specimen.

 Expand...

<Details>

<Screenshots>

Example4: Count of specimen, collected every quater per visit site.

 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:

  • No labels