Returns the paired value associated with the highest number. The aggregator takes two arguments. The first argument is the number used for the ordering. The second argument is the paired valued, one of them being returned.
table T = with
[| as A, as B |]
[| 2, "c" |]
[| 0, "a" |]
[| 1, "b" |]
V = argmax(T.A, T.B)
show scalar "T.B value at highest T.A" with V
Remarks
If multiple rows share the maximum value in T.A, then argmax returns the corresponding T.B from the first row encountered in the table’s default order. Since argmax processes the table sequentially, its result may vary if the row order changes—even when the underlying data remains unchanged.