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.
4 Replies
Anonymous , a new column
Status Colour Code = Switch ( Job Status,
"SUCCESS" , 1,
"FAILED" , 2,
"CANCELLED , 3
)
Status Colour Code =
SWITCH (
TRUE () ,
Job Table[Job Status] = "SUCCESS" , 1 ,
Job Table[Job Status] = "FAILED" , 2 ,
Job Table[Job Status] = "CANCELLED" , 3 )Anonymous Hope this is what you're after 🙂
You may need to write the table as 'Job Table' rather than Job Table.
