Aristotle Support

Aggregates

Article ID: 754
Last updated: 07 Mar, 2010

Aggregates

Aggregates are used to target based on multiple entries within a single table. For example, using the amount (non-aggregate) field in table AllContributions, you can select individuals who have given $100 or more at a single time.

 

Using the aggregate field Total Amount you can select individuals who have given a total amount of $100 or more, no matter how many contributions they made to reach that sum. Other aggregates are Average, Largest, Smallest and Count.

 

When an aggregate is used in combination with other statements in a sub-query, only the entries selected by those other statements will be considered in calculating the aggregate.  For example, if you enter the following query:

 

Sub-Query Join

Table

Field

Relational Operator

Value

 

MonetaryContributions

checkdate

is less than

1/1/2000

and

 

Category

(Fourth of July Event)

 

 

 

TotalAmount*

is greater than

100

 

the results will all be records who have a contribution of $100, who also have a checkdate before 1/1/2000 and are in the Fourth of July Event category.

 

Counts and Sub-Queries

The option to Show Counts will give you a running total of record counts as your query is calculated.returned by each statement of your query.  Because sub-queries are executed as a single unit, the entire sub-query will only return a single count number in this running total.

This article was:   Helpful | Not helpful Report an issue


Article ID: 754
Last updated: 07 Mar, 2010
Revision: 1
Views: 372
Prev     Next
"Or" Sub-Query Joins       Standard Reports