Forum Discussion
undefined
Create a calculated column in Job Table as "Status Colour Code" where Job Status = "SUCCESS" should be 1, "FAILED" should be 2, "CANCELLED should be 3"
You may need to write the table as 'Job Table' rather than Job Table.
Anonymous , a new column
Status Colour Code = Switch ( Job Status,
"SUCCESS" , 1,
"FAILED" , 2,
"CANCELLED , 3
)