Skip to main content

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

2 answers
  1. Jul 12, 2021, 10:13 AM

    good morning @Shaon Paul​ 

    you can place your calculation on the color tile on the marks card and

    then insert your colors for each

    good morning @Shaon Paul​ you can place your calculation on the color tile on the marks card andthen insert your colors for each give it a try and if you run into a problem post your twbx hereJim 

    give it a try and if you run into a problem post your twbx here

    Jim

0/9000