ABC
Description
The ABC function performs an ABC Analysis. Such an analysis divides entries in a column into three groups (A, B, C). Group A represents the values with the highest share of the sum of all values. Group C represents the values with the lowest share. The size of each group is defined with thresholds.
Internally, to assign groups, every entry in the column is sorted in descending order. Then, the highest values up to the first threshold (by default 0.8, so 80% of the sum) are grouped into group A. Subsequently, values up to the second threshold are assigned to group B, the rest to group C.
Syntax
[FILTERED_]ABC ( table.column [,A [, B ] ] )
FILTERED_: Optional input, necessary if filters are applied. This option indicates that the result should be recalculated when a filter changes.
A: Optional input to define the share of group A as float. By default 0.8.
B: Optional input to define the share of group B as float. By default 0.15.
NULL handling
If an input value is NULL, it is not influencing the sum of all values. The return value is also NULL.
Examples
[1] ABC of five rows | ||||||||||||||||
| ||||||||||||||||
|
[2] Custom ABC of five rows | ||||||||||||||||
| ||||||||||||||||
|