Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
I am using 2 dimensions and 3 expressions in straight table . My requirement is to change the back ground color based on condition . Can anyone help me to done this .
Dim: Month, Timestamp
Score :
=if(score<=2.5,red(),
if(score>=3.5,green(),Yellow()))
percentage:
=if(percentage<='80%',red(),
if(percentage>='95%',green(),yellow()))
Regards,
Deep.
The expression and condition is correct .
back ground color transparency should be 0% . It working now.
Thanks,
Deep.
If score and percentage are fields, you need to aggregate - sum(score) ..
If they are column names in the table, it should work out ok.
That is not a filed name just a calculation..
The expression and condition is correct .
back ground color transparency should be 0% . It working now.
Thanks,
Deep.