Rank Function Skipping Rank Numbers

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?
0
Answers
-
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?
0 -
@user10570 Are you using beast mode or MagicETL to rank? Can you share the details?
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 307 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 790 Beast Mode
- 78 App Studio
- 43 Variables
- 746 Automate
- 187 Apps
- 475 APIs & Domo Developer
- 68 Workflows
- 16 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive