7 Replies Latest reply on Sep 28, 2017 8:19 PM by Deepak Rai

    Verifying Tableau Visualization CountD of Records vs. Excel Pivot Count of Records..

    andy mason

      Hello again Tableau Community,

       

      I am in the process of trying to understand what is happening with my data where:

       

      In Excel (PIVOT Table):

      Count of REC ID: 5090 Distinct Count of Records

       

      vs.

       

      In Tableau:

      CountD (REC ID) = 5,026 Distinct Count of Records

       

      Any thoughts as to a) Why this is occurring and B) What to do about it so as to allow Tableau to display exactly the number of records displayed by Excel..

       

      Is there something unique about Tableau CountD function that ignores or overlooks some records?

       

      Thanks in advance for any assistance in this matter: