I have a calculated field based on conditions mentioned below for a text based table. Where the outputs are: P Invoice, Non-Accepted Non-P Invoice and Accepted Non-P Invoice. Now if I want to add color for these three outputs(Example: for P Invoice: ⌗67995, Non-Accepted Non-P Invoice: ⌗FFFF6, Accepted Non-P Invoice: ⌗1F0468, I am using hexa codes for color only) in my calculated field then how to modify it? I am new into Tableau so unable to update it. Kindly help:
Calculation code:
IF [p_category]='P Invoice' THEN 'P Invoice'
ELSEIF [p_category]='Non-P Invoice' AND [P Required YN] IN ('Y','Flat Y and N if weighted','Y if not intercompany') THEN 'Non-Accepted Non-P Invoice'
ELSE 'Accepted Non-P Invoice'
END
Thanks
good morning @Shaon Paul
you can place your calculation on the color tile on the marks card and
then insert your colors for each
give it a try and if you run into a problem post your twbx here
Jim