I need to create indicator from one column called "FIELD". Basically, the column has two string values "EOD" and "SOD". The indicator that i need to create is:
If SOD > EOD then red color
IF EOD < SOD then green color
IF SOD = EOD then yellow color
Could anyone please help with this. Thank you in advance.