I am trying to recreate a dashboard where at the moment I cannot get in touch with who developed it, and I can only access it through our Access Point.
The dashboard has a pivot table set up as a risk heat map, vertical Dimension is Impact is 5 to 1 down, Horizontal Dimension is Likelihood is 1 to 5 left to right
I have created this and works fine, but I cannot get the expression background colours to work.
The expression is:
Concat(Distinct [Risk ID],' ')
The expression Background Colour Definition is:
=only({1}if(isnull(R),White(),RGB(R,G,B)))
I cannot see the load script behind, so cannot see how the developer has achieved this,, I have tried a few of ideas found on interent like:
load * inline [
Type,R,G,B,ID
A,255,128,0,1
B,0,255,0,2
];
unsuccessfully,
Can anyone shed any ideas how to achieve the colouring as shown above with that colour definition