cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to set Thresholds for colour rendering with 4 ranges

Hi all,

I have created a calculated column that can take the following integer values among ...

-1

0

1

2

And my requirements are :

if = 2 ==> RED

if = 1 ==> YELLOW

if = 0 ==> NO COLOUR / WHITE

if = -1 ==> ORANGE

I did not succeed to create the appropriate config for the thresholds in the colour rendering area corresponding to this request. Results in column are always written in WHITE even if i set only one range ORANGE bellow 0 RED ABOVE ==> all in WHITE ??????

Would you please give me advice / solution for this request ?

Thanks in advance

P.SARGNON


2 REPLIES 2

andrzej_lecki
Advisor

You probably set wrong renderer on evaluated column. It should be Int.

I made report which present values of some metric using 3 different approaches:

1 - old coloring by threshold

2 - evaluated color + threshold on that column (It is what you requested)

3 - evaluated column and presentation as icon (I do not want to present value)

Here is the result:

And the configuration:

Notice that in icon column I could use evaluated column Color. (The order of column is important!)


Hi Andrzej

Many thanks ... INTEGER was the good format ... it was set to STRING !

It works perfectly now.

Regards

P.SARGNON