Aggregation Methods

Panopticon Designer (Desktop) software supports a wide range of Aggregation Methods. These methods are mathematical computations applied to a set of values. Values may include a group of numbers or numeric field values and variables. It includes basics like Abs, Min, Max, Mean, and Sum, as well as other more complex methods which will be described later on.

The following aggregation methods are available for most variables:

Aggregation Methods	Description
Abs	The sum of absolutes of the selection.
AbsSum	The absolute of the sum of the selection.
Combinations	Returns how many distinct combinations of breakdown column values there are below each node in the hierarchy.
Count	The count of the number of rows in the selection.
CountDistinct	Creates numeric aggregated variables based on the distinct count of text columns.
CountNonZero	The count of non zero values.
CumulativeSum	The cumulative sum based on the currently applied sort order for each leaf node.
CumulativeSumByMax	The cumulative sum of the sum of the value across siblings ordered by the max of the weight column.
DoNotAggregate	Returns the value of a single row, otherwise null.
External	Allows aggregates to be supplied from source data. The external aggregate configuration can be supplied explicitly, defined by the user, or implicitly from the data plug-in.
Harmonic Mean	The harmonic mean of the selection.
Intercept	The intercept of the least-squares line.
Level	The level in the hierarchy for the node or numbered from the leaf.
Max	The maximum value from the selection.
Mean	The mean of the selection.
Min	The minimum value from the selection.
Neg	The sum of the negative values in the selection.
Percentile	The selected percentile.
PercentofParent	For each member item (child node) of a breakdown group (parent node), the percentage share of its value in relation to the parent group value, where the parent group value is calculated as the sum of all group member (child node) values: [single child node value] / [sum of all child node values in the group] The aggregate value is calculated as a ratio between 0 and 1 and will be presented as a percentage value by applying a percent format string in the aggregation settings. NOTE: This aggregate is only available in the Panopticon Visualization Server.
PercentOfTotal	For each group and for each group member at all levels of the breakdown hierarchy, the percentage share of its value in relation to the total data set value, where the total is calculated as the sum across all rows in the dataset. This aggregate is similar to Percent of Parent, with the difference that the denominator or reference is ALWAYS based on the complete dataset: [single node value] / [sum of all rows in the dataset] The aggregate value is calculated as a ratio between 0 and 1 and will be presented as a percentage value by applying a percent format string in the aggregation settings.
PercentofTotalChange	This aggregate should be understood as “Change in (Percent of Total)”, not as “Percent of (Total Change)”. It is the result of calculating PercentofTotal on two different columns, and then calculating the difference between them. The result is presented as the difference in percentage units, n.b. This aggregate is typically used for comparing PercentofTotal based on current values, to PercentofTotal based on previous values. Therefore, the column specified as “Weight Column” in the settings, should be the column containing previous values. The aggregate value is calculated as a ratio between 0 and 1 and will be presented as a percentage value by applying a percent format string in the aggregation settings. Optionally, you can emphasize that the value is a percentage units by customizing the format unit, for example: 0.00%'-units'.
PercentofWeightParent	This aggregate works like PercentofParent, with the difference that a value from one column is compared to a parent level sum of values from another column, which is set as the “Weight column”: [single child node value from a column] / [sum of all child node values from weight column in the group] While PercentofParent will always summarize to 100% at the group (parent) level, this is not the case with PercentofWeightParent, which can summarize to any number, depending on the differences between the Values and the Weight Values. The aggregate value is calculated as a ratio between 0 and 1 and will be presented as a percentage value by applying a percent format string in the aggregation settings.
PercentOfWeightTotal	This aggregate works like PercentofTotal, with the difference that a value from one column is compared to a total data set level sum of values from another column, which is set as the “Weight column”: [single node value from a column] / [sum of all rows from weight column in the dataset] While PercentofTotal will always summarize to 100% across the whole data set, this is not the case with PercentOfWeightTotal, which can summarize to any number, depending on the differences between the Values and the Weight Values. The aggregate value is calculated as a ratio between 0 and 1 and will be presented as a percentage value by applying a percent format string in the aggregation settings.
Pos	The sum of the positive values in the selection.
Product	The product of the selection.
Ratio	The comparison between the sum of a selected measure divided by the sum of the selected weight measure.
Sibling Rank	The numeric rank of siblings within a hierarchy branch.
Slope	The slope of the least-squares line.
Stdev	The Standard Deviation of the selection.
Stdevp	The Population Standard Deviation of the selection.
Sum	The sum of the selection.
TextConcatDistinct	Aggregates text fields to display all possible text values in a comma delimited list.
TextUnique	Aggregates text fields to display distinct values.
Weighted Mean	The weighted mean of the selection, based on a specified weighting column.
Weighted Harmonic Mean	The weighted harmonic mean of the selection, based on a specified weighting column.
Weighted Sum	The sum of the product of the selected field and the weight field.