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

[Anil_Babu_Samineni]

Like this?

[DennisNorton]

Anil,

Yes, very close. But what if I want to keep those colors persistent so that France is always red, Mexico always green, USA always blue, regardless of information brought in/out?

For instance, these screens would be incorrect. I am trying to achieve a color based on dimension value, not on order.

Thanks

[neelamsaroha157]

[DennisNorton]

Neelam,

Thanks, but this will keep colors persistent based on the load order, I believe. If I load India as another country, for example, this throws the colors off. In this example, I want France to remain green, Mexico to remain blue, and Germany yellow from the Before to After.

Before:

After:

Thanks

[neelamsaroha157]

Other option could be adding Background color if your values are limited, but then it would become hard coded and every time there is new country added to data, you need to add that manually.

If values are fixed then only it will make sense.

[Digvijay_Singh]

You may like to store color code along with countries in the script so they are always attached.

[Anonymous]

that is a really good idea ... !

[DennisNorton]

Neelam,

I don't mind them being hard coded, and the values are limited, but they can fluctuate between 2 or 5 values loaded in different orders.

Here's the bottom line - I want the top selections to be independent from the bottom and specifically, persistently color-coded.

Here is the BG color formula I use to hard code colors to my countries. The problem is when I select Country Name from the top filter, I don't want this to affect the coloring of the bottom graph (2nd screenshot)

This selection scenario would work if the colors for Mexico and USA remained blue and green respectively, but they revert to the false condition. The # values remain, but why doesn't the coloring as well?

[Anil_Babu_Samineni · Accepted solution]

Sure, May be attached