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.