Question

Calculate quantile

  • 14 August 2015
  • 3 replies
  • 31 views

Hi, 

 

 

I've searched for the ways to calculate quantile for an attribute in FME with no joy. Does anyone know if there's a transformer or a combination (possibly sorting and then extract the value at a certain row?) that's capable of calculating quartile, percentile etc in FME?

 

 

Cheers.

3 replies

Badge +22

Depending on what exactly you want to do I would either do

 

Sorter, Aggregator (w/ count attribute and list), Deaggregator (part number, explode list), ExpressionEvaluator (some variant of part number/ count)

Or for more complicated analysis

 

 

StatisticsCalculator (histogram, complete port) followed by an ExpressionEvaluator (with possibly some list manipulation of the histogram prior to that)
After a few trials I found it might be much easier to do this in R, although that means that I have to switch between the two softwares. But thanks anyway.

Hi haow,

 

I know it's quite after some time but this might be what you (and others) are looking for - PercentileCalculator, custom transformer at FME Hub.

Reply