Hi Team,

I have a table that shows users.

The users have one row each for what language they can speak. In each row, they also have the country they are in.

Example:

Name - Language - Country

Steve French Germany

Steve Italian Germany

Steve Spanish Germany

Karen Italian France

Karen French France

The country will always be the same on each row for each user.

I want to generate a count of people in each country using a Geo map. Currently in the above sample data, I would get a count of 3 for Germany, and 2 for France. When in reality, I actually only have one user in Germany (Steve) and one user in France (Karen).

I am struggling to determine how to do this. I have tried Discint Count - Normal, etc, I have tried aggregate, and tried a SQL Querie table. I may be on the right path with one of these, but can't seem to make it work.

If anyone can supply me with some ideas or how to do it, that would be awesome.

Thanks

Steve