Percentile calculation

Alfredo Monasi
Alfredo Monasi Experian Employee
in Functions library

Hi everyone, I created a reusable workflow that define wheter a column value is in the 'Percentile' value (for example 95%) or not and also creates a column indicating if you need to smooth a value when reach or surpass that percentile.

It needs a column and a parameter to the percentile to calculate (1%, 5%, 25%, 50%, 75%, 90%,95%… 100%)

Percentile.dmx
Workflow Percentile.png results Percentile.png

Hope it helps someone as helped me!

Categories