Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

ABC

Applies to: CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7

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.

Can be applied to INT or FLOAT columns.

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.

  • column: INT or FLOAT column

  • 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.

Query

Column1

ABC ( "AbcTable"."C1" )

Input

Output

AbcTable

C1 : INT

50

30

8

7

5

Result

Column1 : INT

1

1

2

2

3

[2] Custom ABC of five rows.

Query

Column1

ABC ( "AbcTable"."C1" , 0.5 , 0.3 )

Input

Output

AbcTable

C1 : INT

50

30

8

7

5

Result

Column1 : INT

1

2

3

3

3