1 Reply Latest reply on Jan 3, 2019 8:31 AM by Sarah Bartlett

    Use map as a filter

    romain.boistel

      Hello,

       

      I made a test dataviz from a datasheet with 3 columns Name, Country and Year.

       

      A name can appear several times associated with different countries (let's say the countries they visited), and a country can appear several times associated with different names.

       

      I made 2 maps:

      1. The visited countries by year
      2. Given a country A visited a given year, the other countries that were visited by the people who also visited country A (see http://vizdiff.blogspot.com/2016/08/lookup-via-association.html).

       

      I then a made a dashboard with these two maps, which have the Year filter in common. There is a drop-down list of countries to select the targeted country for the second map.

       

      I now have 3 questions:

      • The drop down list of countries is build from a parameter, not from a filter, so the option "Only relevant values" is not available. All the countries are listed even when they were not visited that year. How could I list only the relevant values? e.g. base the list of values of my parameter on a filtered list with only relevant values.
      • On the dashboard I would like to use the first map as a filter for the second map instead of the drop down list of countries. Problem is the drop down list is not built from a filter but from a parameter, so the first map can't work as a filter. How could I still filter with the first map? Maybe solving the first question also solves the second.
      • Is it possible to highlight the selected country on the second map?

       

      Sorry I'm still a very beginner. I'm already impressed by what I did (even if I struggle a lot) :-)

       

      Thanks a lot

       

      Romain