Rank Function Skipping Rank Numbers

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?


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

  • 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?

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