Hello there,
You can break the tie by creating a calculated field that uses multiple sort fields in your rank function.
Syntax
rank
(
[ sort_order_field ASC_or_DESC, … ]
,[ partition_field, … ]
)
Example
rank(
[max({ Data}) DESC,Name ASC]
)
1 Like