Last Modified Date: 18 Jan 2019
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 Distinct.Discuss this article... Feedback Forum
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