Duplicate (but independent fields) as data island

[DennisNorton]

I am having trouble with this comparison scenario using a data island, and properly colorizing a bar chart by dimension values.

Graph 1 - Sum(sales)

Graph 2 - Sum({<CountryName = p(Island.Country)>} Sales)

A selection made on CountryName should not affect the values of graph 2, and I think I have that operating correctly. The problem is when I am coloring by dimension and make a selection on CountryName. Graph 2 colors drop off, but the numbers and dimension values remain. Am I using the wrong dimension or possibly the incorrect background color formula?

Thanks

[DennisNorton]

Perfect, thank you!

As an aside, I was curious if there's a way to have the same coloring functionality, but with Island.Country as the dimension instead of CountryName. There is still dependency between the two if I make a selection within the bottom chart, since it uses the original CountryName field.

[neelamsaroha157]

Check the attached sample.

[Anil_Babu_Samineni]

May be use this in script in end of the script?

Left Join(Island)

LOAD * Inline [

Island.Country, R, G, B

France, 244, 66, 66

Mexico, 66, 244, 98

USA, 66, 134, 244

];

And use BG Color expression like RGB(R,G,B)

[neelamsaroha157]

Even after the background color expression you need to check 'Persistent Color'.