It would be really useful for certain cases if the RANK function could generate a sequential output when dealing with tied data.
Currently, the RANK function can deal with tied entries in 4 ways, MAXIMUM, MINIMUM, AVERAGE and SEQUENTIAL and all handle tied data in a slightly different way but do not generate an output in which items are ranked as 1,2,3,4,5 in an incremental way. The output skips rankings when using MAXIMUM, MINIMUM and AVERAGE and ignores tied rankings when using SEQUENTIAL.
This is a bit difficult to explain in words so please see the attached image showing the outputs currently generated by RANK and the desired output which it would be good to add as an enhancement to the RANK function.
If any members of this community fancy a challenge and can show an alternative neat and performant way of generating this output then I'd love to hear it!
