Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys Below is the input data, in this on the basis of Test Measure output, there Color coding required. Please suggest
ID | iss | Rss | Test | OUTPUT Required |
C162383 | 2C/1M | 2C/1H | C/H/M/L | RED/RED/AMBER/GREEN |
C165007 | 1C/1H | 1H | C/H | RED/RED |
C165939 | 1M | 1M | M | AMBER |
C172291 | 1L | 1L | L | GREEN |
C174646 | 1H/1L | 1C | H/L | RED/GREEN |
I think if conditions should work; sthing like:
if(Test='C',Red(),
if(Test='H',Red(),
if(Test='M',Amber(),
if(Test='L',Green()
))))
thanks , I tried but w.r.t single output it is working but if I have multiple string king output like C/H/M/L its not working
And u want to show this in a table object?
yes
You can't do that; you can't color a cell in a table with different colors..
ok , is it possible to color values from backend?
except if he create 3 columns to display in each one the color he want , by the master dimensions of the same field Test
and in the content of the column just show nothing like : if(len(test)<>0,' ') and also title if you want to change it,
and in expression of background color put for the first column you created this :
if(test='C',Red(),
if(test='C/H/L',blue(),
if(test='H/L',Red(),
)))
in the second one :
if(test='C/H/L',Green(),
if(test='H/L',green(),
))
and continue on the same logic