Page tree

Versions Compared


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



Computes the rolling unique kth largest value forward or backward of the current row. Inputs can be Integer, Decimal, or Datetime.

For purposes of this calculation, two instances of the same value are treated at one value for k. So, if your dataset contains four rows with column values 1099, and 8, then KTHLARGESTUNIQUE returns 9 for k=2 and 8 for k=3.


Name of the column whose values are used to compute the function. Inputs must be Integer, Decimal, or Datetime values.


NOTE: If the input is in Datetime type, the output is in unixtime format. You can wrap these outputs in the DATEFORMAT function


to output the results in the appropriate Datetime format. See DATEFORMAT Function.

  • Multiple columns and wildcards are not supported.


Required?Data TypeExample Value
YesString (column reference to Integer or Decimal values)myColumn


Integer representing the ranking of the unique value to extract from the source column. Duplicate values are treated as a single value for purposes of this function's calculation.