...
For more information on the group and limit parameter, see Pivot Transform.
col_ref
Name of the column whose values you wish to use in the calculation. Inputs must be Integer or Decimal values.
...
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String that corresponds to the name of the column | myValues |
k_integer
Integer representing the unique ranking of the value to extract from the source column.
...
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.
test_expression
This parameter contains the expression to evaluate. This expression must resolve to a Boolean (true or false) value.
...
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | String expression that evaluates to true or false | (LastName == 'Mouse' && FirstName == 'Mickey') |
| D s | ||
|---|---|---|
|
Example - Second-most measurements for a specific city
| Include Page | ||||
|---|---|---|---|---|
|
...
