Last Modified Date: 19 Jun 2017
Environment
- Tableau Desktop
Answer
In 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 Information
Tableau Blog article: Tips & Tricks: Alternatives to Count DistinctThank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials