I dont know about your data structure. It will be more helpful If you share some sample data in text format or the workbook in .twbx format. I think I can help you.
Lets assume your columns are measures then you can create a calculated field like this
IF SUM([Total])>SUM([High]) THEN 'Red'
Drag this calculated field to color in Marks card and manually change the color of the legends.
1 of 1 people found this helpful
It appears that your Low and High Columns are there as thresholds for an acceptable range. In this case your formula is going to look a bit different.
SUM([Total]) <= SUM([High]) AND SUM([Total]) >= SUM([Low])
This will return a Boolean where it returns true if you're inside the range and false outside the range. You then need to bring this field to the colours shelf of your marks card and change false to red and true to green.
If you prefer to use logic instead of a boolean try this
IF SUM([Total]) <= SUM([High]) AND SUM([Total]) >= SUM([Low]) THEN 'Green' ELSE 'Red' END
Many thanks Carl,
This is exactly what I needed. I used the logic way and worked perfectly.
When beginning to use Tableau everything seems complicated but
little by little, it is making sense.
thank you again!