I'm about to head out, so I didn't address Question 1, but for Question 2, you can use a discrete (blue pill) version of this calculated field:
IF AVG([Number]) < 30 then 1
elseif AVG([Number]) < 51 then 2
else 3 end
You could use "Red", "amber", and "green" as the THEN part of the statement, but I tend to use numbers and alias them for performance reasons. Either way, you'll get the result you want:
Sample Maps Coloring.twbx 182.7 KB
Shawn, thanks for the reply.
I am unable to attach anything in this discussionm else I would have shown you my struggles.
When I drag the color calculated field in the color marks, I don't get the format legend option where I can set the value of '1' '2' and '3' to desired colors. Instead, I get the stepped color legend and I can't adjust the colors
Also, when I drag the colors field from in the color shelf, my original number are replaced by the value of the color filed all across the dashboard (1, 2 and 3).
Please help as this is really critical.
It needs to be a DISCRETE (blue pill), not CONTINUOUS (green pill)
Also, if the requirement is URGENT, you might consider Tableau Support or one of the many consulting firms they partner with. This Forum is a community of Tableau users, and we are all volunteering our time. Therefore, marking something as "urgent" here isn't really going to make any difference as this is not a help desk/support forum. I hope that makes sense, and I do not intend to offend!
Shawn, I was able to solve that myself. I just changed the continous to discreet in the color marks and I was able to resolve that.
Thanks a lot for the great help guys.