KNOWLEDGE BASE

How To Reduce Performance Cost of Count Distinct


Published: 14 Mar 2016
Last Modified Date: 19 Jun 2017

Question

How to reduce performance cost when querying large datasets and using COUNTD.

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:

 
Did this article resolve the issue?