atoti.array.nth_greatest()

atoti.array.nth_greatest(
    measure: VariableMeasureConvertible,
    /,
    n: PositiveInt | VariableMeasureConvertible,
) → MeasureDefinition

Return a measure equal to the n-th greatest element of the passed array measure.

>>> pnl_table = session.read_csv(
...     TEST_RESOURCES_PATH / "csv" / "pnl.csv",
...     array_separator=";",
...     keys={"Continent", "Country"},
...     table_name="PnL",
... )
>>> cube = session.create_cube(pnl_table)
>>> l, m = cube.levels, cube.measures
>>> m["3rd greatest"] = tt.array.nth_greatest(m["PnL.SUM"], n=3)
>>> cube.query(m["PnL.SUM"], m["3rd greatest"])
                          PnL.SUM 3rd greatest
0  doubleVector[10]{-20.163, ...}         -.53

Parameters

measure

VariableMeasureConvertible

n

PositiveInt | VariableMeasureConvertible