I have a bunch of different queries pulling back a singular data point which I then have a calc analyzing the data point based on threshold, and returning a status.
IF [data.WebsiteFlightSearchElapseNonFlex] >= 20 THEN "Bad"
ELSEIF [data.WebsiteFlightSearchElapseNonFlex] >= 35 THEN "Critical"
ELSEIF [data.WebsiteFlightSearchElapseNonFlex] <= 15 THEN "Good"
I want to show my results in colors green, yellow, light red, dark red. This works by dragging the calc into the color section on the marks card. However the colors auto assigned are not what I want, and because it is a singular result, to get the colours I have to manually edit the thresholds in every calc, so that I see each result bad/critical/good/medium, to then edit the color.
Its taking me ages, any ideas?
I might be misunderstanding you but I think this article might help out:
If the above doesn't help, can you provide step by step instructions of what you are doing along with a sample packaged workbook to help the community better understand your issue?