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.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 437 Beast Mode
- 23 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive