Issue
The RANK() function shows two unique ranks for the same integer number like below:
Last Modified Date: 10 Dec 2020
Environment
- Tableau Desktop
Resolution
The resolution is to make a calculation field to round the numbers to the values that are shown in the view.RANK(ROUND(AVG([Sales])))
Cause
The values that appear to be the same in ranks are actually rounded to display without decimal numbers.(eg. "1500" shown in the view, while "1499.9750" are used in ranking)
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials