| D toc |
|---|
| Excerpt |
|---|
Extracts the ranked value from the values in a column, where |
10, 9, and 9, then KTHLARGEST returns 9 for k=2 and k=3.When used in a pivot transform, the function is computed for each instance of the value specified in the group parameter. See Pivot Transform.
Input column can be of Integer or Decimal type. Non-numeric data in the column is ignored. If a row contains a missing or null value, it is not factored into the calculation.
D s snippet Basic
| D code |
|---|
pivot value:KTHLARGEST(myRating, 2) group:postal_code limit:1 |
Output: Generates a two-column table containing the unique values in the postal_code column and the second highest value from the myRating column for that postal_code value. The limit parameter defines the maximum number of output columns.
| D s | ||
|---|---|---|
|
| D code |
|---|
pivot value:KTHLARGEST(function_col_ref, k_integer) [group:group_col_ref] [limit:limit_count] |
| Argument | Required? | Data Type | Description |
|---|---|---|---|
| function_col_ref | Y | string | Name of column to which to apply the function |
| k_integer | Y | integer (positive) | The ranking of the value to extract from the source column |
For more information on the group and limit parameters, see Pivot Transform.
| D s lang notes |
|---|
function_col_ref
Name of the column the values of which you want to calculate the mean. Column must contain Integer or Decimal values.
- Literal values are not supported as inputs.
- Multiple columns and wildcards are not supported.
| D s | ||
|---|---|---|
|
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String (column reference) | myValues |
k_integer
Integer representing the ranking of the value to extract from the source column.
| Info |
|---|
NOTE: The value for |
k=1represents the maximum value in the column.- If k is greater than or equal to the number of values in the column, the minimum value is returned.
- Missing and null values are not factored into the ranking of
k.
D s snippet usage
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | Integer (positive) | 4 |
| D s | ||
|---|---|---|
|
Include Page EXAMPLE - KTHLARGEST Function EXAMPLE - KTHLARGEST Function
D s also label aggregate
