3 Replies Latest reply on Sep 21, 2017 1:17 PM by andy mason

    Understanding Why Data Difference from Excel to Tableau Count of Records

    andy mason

      Hello Tableau Community,

       

      I am trying to understand what is happening with my data where:

       

      In Excel (PIVOT Table):

      Count of REC ID: 5075 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..

       

      Thanks in advance for any assistance in this matter:

       

      Andy