This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
the logic there works - assuming:
a) that status is already populated.
b) that you want Blue to trump all other colors
c) an empty field is preferable to some kind of base color.
in a formula you'd have to be clear that you are modifying "final color" and not entering a new field.
Thanks..but in my use case this fails since I have to ensure that 2 combinations of the colors are to be marked
if contains([Concat_Color],"Blue") then'Green'elseif contains([Concat_Color],"Amber") then'Amber'elseif contains([Concat_Color],"Red") then'Red'else""endif
BLUE = No Red, No Amber, No GreenRED = RedAMBER = Red, AmberGREEN = Red, Amber,Green
Please advise based on the conditions...thanks !
@DigitMacYou should be able to get what you want by a simple edits to @danilang 's workflow.
Open up his formula - and swap out the first color tested from "Blue" to "Green" and then change the final else from "" to "Blue"
if contains([Concat_Color],"Green") then'Green'elseif contains([Concat_Color],"Amber") then'Amber'elseif contains([Concat_Color],"Red") then'Red'else"Blue"endif
This is what I was asking about yesterday in terms of color dominance - it sets "Blue" as the absence of other colors and "Green" as the dominant color.
Hi @apathetichell @danilang
What helped was a combination :
I created a calculation after summerize as indicated with below logic
Step 2 :
if [Concat_Color] ="Red,Amber" then'Amber'elseif [Concat_Color] = "Red,Amber,Green" then'Green'elseif contains([Concat_Color],"Red") then'Red'else[Concat_Color]endif
By doing this I could exactly select 15 characters and the combinations work well for my dataset 😀
Thanks for your support and this worked !