## Key

• This line was added.
• This line was removed.
• Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

Excerpt

Extracts the ranked value from the values in a column, where where `k=1` returns returns the maximum value. The value for for `k` must must be between 1 and 1000, inclusive.

For purposes of this calculation, two instances of the same value are treated as separate values. So, if your dataset contains three rows with column values `10` , `9` , and `9` , then `KTHLARGEST` returns `9` for `k=2` and `k=3` .

When used in a `pivot`  transform transform, the function is computed for each instance of the value specified in the `group` parameter.  See 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 code

pivot value:KTHLARGEST(myRating, 2) group:postal_code limit:1

Output: Generates a two-column table containing the unique values in the the `postal_code` column and the second highest value from the the `myRating` column for that `postal_code` value value.  The The `limit` parameter parameter defines the maximum number of output columns.

D s
snippet Syntax

D code

pivot value:KTHLARGEST(function_col_ref, k_integer) [ group:group_col_ref] [limit:limit_count]

ArgumentRequired?Data TypeDescription
function_col_refYstringName of column to which to apply the function
k_integerYinteger (positive)The ranking of the value to extract from the source column

For more information on the the `group` and and `limit` parameters parameters,  see see Pivot Transform.

D s lang notes

...

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.

...

• `k=1` represents 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 of `k`.

D s
snippet usage

Required?Data TypeExample Value
YesInteger (positive)`4`

...

Include Page
 EXAMPLE - KTHLARGEST Function EXAMPLE - KTHLARGEST Function

D s also
label aggregate