Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can we assign background color in the edit script apart from the dimensions box
Hi Sunny. It can be done using a variable.
In the edit script: vDim1Color = 'If(Dim1 = 'A', Green(), Red())';
In the dimension box: $(vDim1Color)
Yes it is possible, if you have the RGB values.
Hi,
I've done something like this a few times. Assuming my dimension is [Country]:
Country_Colors:
LOAD * inline [
Country, R, G, B
USA, 255, 0, 0
Germnay, 0, 255, 0
France, 0, 0, 255
];
Then in background color expression I used
RGB(Only(
), Only( ), Only())
Thanks for the reply Andrey,
is there possibility to change background color if cell value is changed/updated