PercentileCont
The PercentileCont macro performs the same calculation as the SQL query term PERCENTILE_CONT. It performs an interpolation along an ordered sequence of values, answering the question "what value would have appeared at this fractional position along the sequence?"
Group records by a group field.
Within each group, order the records on a specified value field.
Assign each record a distribution number such that the first record gets 0.0 and the last one gets 1.0; records in between are linearly interpolated.
Find the two records whose distribution values are on either side of "percentile" (actually fractional) value P.
PercentileCont configuration parameters
PercentileCont has a single set of configuration parameters:
P | Percentile value, which must be between 0.0 and 1.0. |
Group field | Mapped field containing the grouping key. |
Value field | Mapped field containing the values, which must be numeric. |
Configure PercentileCont
Select the PercentileCont icon, and then select the Configuration tab on the Properties pane.
Select P and enter a percentile value, which must be between 0.0 and 1.0.
Select Group field and select the input field containing the group key.
Select Value field and select the input field containing the numeric values.
Optionally, go to the Execution tab, and then set Web service options.