Applies to: CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6
ZScore can act as a standardization of data by mapping each value to the distance to the mean in multiples of standard deviations. This is especially useful in evaluating simple 2-, 3- or 6-sigma rules for outlier detection on a column.
- The calculation is parallelized. The function first calculates the variance in two parallelized passes over the data in the column then the ZScore over the unique values of the column is calculated in parallel.
- The ZScore of large FLOAT columns can have a large error.
- ZScore over DATE columns should utilize a DateTime projection function.