Calculation Aggregation
Calculation aggregation is sometimes needed with calculated columns.
If the Calculation aggregate is used, any calculated columns will be re-executed up the hierarchy, so that the calculation is done on group-level aggregates instead of row-level values. Furthermore, each term in the calculation will be summed by default, but this can be controlled if a different aggregation is needed.
The aggregation applied to each column included in the calculation expression can be specified using the following syntax:
[term:aggregate]
For example:
[exposure:sum]/[risklimit:mean]
[exposure]/[risklimit:mean] also has the same result since no aggregation specified defaults to sum
NOTE |
Most of the Panopticon aggregation methods are supported, except those that involve more than one column.
|
You can specify any of the following functions:
q abs
q abssum
q count
q countdistinct
q countnonzero
q harmonicmean
q level
q max
q mean
q min
q neg
q percentofweightparent
q percentofweighttotal
q pos
q product
q siblingrank
q stdev
q stdevp
q sum