Last Modified Date: 19 Jun 2017
- Tableau Desktop
AnswerIn Tableau Desktop Count Distinct may be a performance expensive operation, because every single record needs to be compared against every other record in order to find how many unique items there are in a dataset.
The only ways to overcome this loading time issue are:
- Optimizing the query time through indexing
- Using an extract as detailed in the following Knowledge Base article, Improving Database Query Performance
Additional InformationTableau Blog article: Tips & Tricks: Alternatives to Count Distinct
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials