2 Replies Latest reply on Nov 20, 2018 5:43 PM by Peter Fakan

    Sum of Matching Locations

    Jan Janus

      Hello Guys,


      I am new user of Tableau and I have a problem of summing up the Matching Locations. I want to visualize a sum of records for each country. My data set contains a column called SiteName which cotains duplicates because the record is connected to same site. What I want to do is to visualize a sum of all records that I manually matched for all of the countries. I work with confidential data so I cannot share the content with you but my tableau is set to use:

      Longitude as Column

      Latitude as Rows

      SUM(Number of records) in Colours

      SiteName column set to Geo-Country


      Is there a way to create a calculation to sum up al the entries for particular latitude and longitude?