Non-standard use of Rank() function

[vlad_komarov]

I have a request from the client for non-standard ranking display.

My results have some cases when the values are identical and the ranking based on this value is the same.

The normal QV implementation (rank(sum(Score), 0, 0)) produces the following result (positions 15 - 18):

Client wants to have the rank displayed the following way (three ##15s and #16 at the next position):

I was not able to find the option to do that. The closest result was to use the rank((sum(Score)),0, 1), which produced the following:

Any suggestions how to implement this request will be greatly appreciated.

Best regards,

[johnw · Accepted solution]

Well, this seems like a horrible solution, but it seems to work and I haven't thought of a better one.

match(rank(-sum(Score),0,1),$(=concat(distinct

aggr(rank(-sum(Score),0,1),ID),',',
aggr(rank(-sum(Score),0,1),ID))))

[vlad_komarov]

Thanks John!

It works exactly like needed.

Regards,

Vladimir

P.S. I like your solution on "negative" rank: (rank(-sum(....)). Looks cleaner than 1/sum(...) one I've used.

Thanks again