6 Replies Latest reply on Jul 25, 2018 7:17 PM by Ritesh Bisht

    How Do I Resolve Duplicate Counts In Various Administrative Geographies, Using Zip Code As Foreign Key?

    philip.watkinson

      Hi,

       

      I am using TIGER shape-files for various State and Federal administrative geographies, but the foreign key that I am having to join the count of patients, providers, etc. is the common Zip Code. This results in duplicated counts in overlapping Zip Codes, even when I select a Count Distinct measure. How can this be resolve, if at all?

       

      Thanks