Some sample data would be great to show you how it works
What happens when you put your calculated field on Color ? The syntax is correct if you're showing [SV%], but it looks like that's only the first bar in the graph
You might need to put 2 dimensions on Color to make it work properly.
Since you did not give workbook, I use superstore as a sample.
Make a calculated field:
IF SUM([Sales]) / TOTAL(SUM([Sales]))>0.1 THEN 'Blue'
ELSEIF SUM([Sales]) / TOTAL(SUM([Sales]))>0.07 THEN 'Yellow'
ELSEIF SUM([Sales]) / TOTAL(SUM([Sales]))>0.04 THEN 'Brown'
Put it in "Color", you will get it.
Hope it helps,
When I drop the calculated field into color it turns the entire graph one color, and even if it recognizes it should be red or blue it's still constantly one color, whether that color is correct or not.
Understood, that's why I said you might need 2 dimensions on Color.
That is exactly what I want to do but it unfortunately won't let me look at your workbook for some reason.
What version of Tableau are you using ?
I created the workbook using 10.3.2, so I was guessing you were using that or higher.