5 Replies Latest reply on Nov 19, 2018 6:44 PM by Chris McClellan

    Data Join - Values skewed

    Amirah Thompson

      After joining data, values are being skewed - not doubled, or tripled, but increased at every level. In the below, focusing on the month of September, the sample agent took 215 calls.  After adding in the second join, the calls jump to 299.  I've tried the inner and left join only - both provide the same results.

       

       

      Here is the data without the second joined query.

       

       

      The main source is in access and the joining field is date.