ABC Analysis
Use
You can set-up an ABC Analysis for every interactive basic list, every statistic, and every ranked list containing at least one numeric field.
For the ABC analysis the data records of a dataset are divided into three groups (A segment, B segment, C segment). Each of the data records must include a key figure (a numeric field) and an arbitrary number of other characteristics (non-numeric fields). The dataset is initially sorted on the key figure in either descending or ascending order. There are four ways of dividing the data records into groups:
-
Key figure (percentage)
Division into groups is performed by treating the key figures as percentage proportions of the overall total. For example, if the following distribution is chosen: A=50%, B=30% and C=20%, then the data records are allocated to segment A until 50% of the total number of data records have been allocated. The data records will then be allocated to segment B until the partial sum of the key figures reaches 80% (50+30) of the sum of all the key figures. All other data records will be allocated to segment C.
-
Key figure (absolute)
Division into groups is performed by treating the key figures as absolute values. Two limiting values must be specified: the limiting value between the A and B segments and the limiting value between the B and C segments. The data records are then assigned to the individual segments using these limiting values.
-
Characteristics (percentage)
Division into groups is performed by treating the number of data records as percentage proportions of the overall total. For example, if the following distribution is chosen: A=50%, B=30% and C=20%, then the data records are allocated to segment A until 50% of the total number of data records have been allocated. The data records will then be allocated to segment B until the partial sum of the key figures reaches 80% (50+30) of the sum of all the key figures. All other data records will be allocated to segment C.
-
Characteristics (absolute)
Division into groups is performed by using a fixed number of data records. For example, if the following distribution is chosen: A=10, B=20 and C=... , then the first 10 data records are allocated to segment A, the next 20 to segment B and all remaining data records are allocated to segment C.
Activities
The following interactive functions are available for the results list of the ABC analysis: