You just need to use the correct IF THEN syntax for Tableau.
IF [Value] <0 THEN "Red"
ELSEIF [Value] >=0 AND [Value] <= 7 THEN "Yellow"
You should just be able to create a calculation in Tableau, paste in my formula, and then drag this new calculation to color. It will create 3 distinct colors for each Red/Yellow/Green result of the calculation - you just need to assign the correct colors to each.
How to force color legend to respect the costraints:
RED, if is between >0 and < 7 , then YELLOW and, finally, if is > 7, then GREEN ?
May you provide me a working example?
Thanks in advance.
Have you tried to paste my calculation into your workbook?