Invantive Vision

Aggregation Methods

In this screen you can register and edit aggregation methods. Open screen in browser Open Form

An aggregation method is an allocation of days in a time range in summaries. An example:

•Today: today.

•Last week: 1 till 7 days ago.

•Last month: 1 till 30 days ago.

•etc.

Aggregation Methods Screen

The meaning of the entry fields is:

Code	The code with which is refered to the aggregation method.
Description	The description of the aggregation method.
#Units	The number of units to be aggregated.
Unit of Time	The time unit over which the aggregation takes place.
Label Expression	SQL expression that calculates the first day in the period. All variables of type ‘: start_date’ will be replaced by the first day in the period. They are summed for all times after the previous period specification. For example: •2 days --> day 0 till 2. •7 days --> day 2 till 7. •1 month --> day 7 till the end of the month which contains day 7.