a scatter plot challenge

[#1]

hi

My file is quite simple

   - City

   - Country

   - v1

   - v2

Each city belongs in one county. A country is a set of cities !  v1 & v2 are 2 numeric variable.

I created a scatter very easily.

My scatter doesn't depend of the selection of a city.

To achieve this, my expressions are  sum( {1} V1) and sum( {1} V2).

I'd like to design my scatter plot with a color coding

An user choose a city in a list box then I'd like to get

   - selected city  in Blue

   - cities of the county  where the selected city belongs  in  red

   - other cities in grey

I know to color only the selected city with

=if( GetFieldSelections(City)=City , color(1) , color(2))

but I don't know to colorize the others in 2 groups

Thanks for your help

JJ

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[#3]

Thanks Gysbert

Nice expression

=count({<City=p({<City=,Country=p(Country)>}City)>}City)

regards

JJ

[#4]

How to add the first dimension legend and colur code also based on the First Dim legend ?