10 Replies Latest reply on Feb 12, 2019 1:10 PM by Paul Wachtler

    Some records are showing up as duplicate in Tableau but not in the database (backend)

    Carmen Torres

      I'm trying to populate a worksheet that retrieves hospitals that meet certain criteria.  The hospitals that are retrieved are correct; however, when I add a calculated field to display the patient count, several hospitals have their count as a multiple of two.  When I look at my backend database (SQL), there are no duplicates.  I do not understand why most of the counts are correct but only a few hospitals have their count as a multiple of two.

       

      When I view the data in Tableau, I can see those records that are coming in as duplicate.  I do not know how to resolve this issue.  Can someone point in me in the right direction?  Thank you in advance.