Color coding for certain field

[#1]

Hi everyone,

I am trying to make mapping for color coding in one field and so far no luck. I want to have colors for values of this dimension override default setting (as I understood default color coding is based on load order).

The only thing that worked was to sort field values in Excel file, sort them in some way, and make Default Colors in the document in that order.

Is there any other way to do this just for one field?

Regards

[disqr_rm]

You can expland the + under dimension field you are interested in and under respective area you can code however you want. You can code it like: if(value = 0, red(), blue()) or so. Under text formatting you can also specify things like: if(value = 0, '<B>') to make it bold.

Hope I answered what you are looking for. Otherwise, just upload a sample of what you are trying to achieve.

[#3]

Hi Rakesh,

Thanks for the idea. I tried that, but it takes too much coding on each chart, for every value and so on. And I didnt manage to get it to work quite right 🙂

I tried to load RGB values in separate fields and set color dynamicaly like that, but its not working neither in Dimensions or Expressions page the way I hope to make.

Heres how I tried.

1) First, there is this Excel file with Item Type values and Colors that should represent them. This is loaded before actual values from DB.

2) Second step is to change Document Default Colors to match those from Excel file

3) Now the chart looks like something like this

Ok, so it works for this simple scenario. But if I wanted to make similar Color Coding (with different colors 1,2,3 ..) also for, for examle, Customer groups, that couldnt be done this way. I hope to make it work across whole application.

Ideal solution would be to have the ability to have individual color page for every field, so default setting could be changed on micro level. Is this available?