topic Re: Filter list of countries by single country in map in Visualization and Usability

Filter list of countries by single country in map

karamicha — Sat, 16 Nov 2024 20:01:42 GMT

Hello all,

I want to filter a table that contains rows with multiple countries, comma separated. The filter will be selected in a map chart which includes all the countries one by one.

For example:

I have the Projects table with the following structure:

Title	Geographical coverage
Project #1	Algeria, Nigeria
Project #2	Nigeria, Cameroon
Project #3	Cameroon

And when I filter in the map chart the country Nigeria, I want to show only Project #1 and Project #2 in the table.

Note that I managed to do it when I have duplicated rows with single countries, but I want to use the filter if the country exists in a list of countries in each row without duplicates.

Re: Filter list of countries by single country in map

NoviceUser — Wed, 13 May 2020 14:37:55 GMT

I would like to know the script to do that as well.

Re: Filter list of countries by single country in map

karamicha — Thu, 14 May 2020 18:31:31 GMT

Hello NoviceUser,

I finally managed to make it work by removing the row of the countries from the table and I kept only the map chart with the countries.

When I am filtering the countries now from map chart, by selecting one by one, the results that contain the country in their Geographical coverage row, appear as filtered results in the table.

I hope it helps!