Multiple Ranking Criteria

[#1]

Hi Qliks,

I was wondering if there is a best practice for rank calculations in case of same ranks. The given use case is a soccer scoring table, where teams may end up with the same score and ranks are assigned by a second criteria which could be the number of goals.

Any idea or sample is highly welcome

Thank you!

Florian

[swuehl]

You can calculate a new score from score and # of goals like: SCORE + GOALS / 1000

Like

TEAM, SCORE, GOALS, NEWSCORE

A, 80, 63, 80.063

B, 80, 70, 80.070

C, 77, 100, 77.100

Team B ranks highests.

If you've got multiple Criteria, you could extend this easily. You only need to define the maximum value range for each criteria, then map the results of each criteria into distinct value ranges, like

SCORE *1000 + GOALS + WON / 100

Hope this helps,

Stefan