Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Status field of the customer details Staright table.I want to change background color of the status field. Status field is set in Dimension.
ex;-
if customer status is "Active"then the display should be in active.
if Onhold then yello
if Inactive then RED
Thnaks!!
Open the properties window of the straight table. Go to the Dimensions tab and click on the + in front of the Status dimension. Now click on Background Color and then click the Edit button. Now you can enter an expression to calculate the background color. Something like: if(Status='Active',lightgreen(),if(Status='On hold', yellow(), if(Status='Inactive', lightred()))).
apply the condition in the background color of desired dimension:
and put if condition like:
if(Status='Active',lightgreen(),
if(Status='On hold', yellow(),
if(Status='Inactive', lightred())))
HTH
Sushil