Rank Function Skipping Rank Numbers

Options
lb1234
lb1234 Member
in Beast Mode

I'm creating a simple leaderboard which ranks my closers by the number of sales for the selected period and then by total system cost. For some reason, the function I'm using is causing the leaderboard to skip ranks and I'm having trouble figuring out why. Any thoughts?

Screen Shot 2022-12-08 at 11.07.35 AM.png


Answers

  • MichelleH
    MichelleH Coach
    Options

    @lb1234 Try using DENSE_RANK() instead of RANK() to make sure numbers don't get skipped

  • user10570
    user10570 Member
    Options

    I'm also having this problem. I don't want dense rank, because I do have ties in the data and I want those numbers skipped. My dataset has two values that tie for 1st, but then the next is 4th when it should be 3rd. Is this a known bug or is there something in the config that should be changed?

  • MichelleH
    MichelleH Coach
    Options

    @user10570 Are you using beast mode or MagicETL to rank? Can you share the details?

Categories