Overview
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.
|
Parameter |
Description |
|---|---|
|
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.
-
Go to 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 choose the input field containing the group key.
-
Select Value field and choose the input field containing the numeric values.
-
Optionally, go to the Execution tab, and then set Web service options.