I have created a calculated column that can take the following integer values among ...
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
Solved! Go to Solution.
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!)