I think you mean the Y-axis, but if you want everything less than 2 to be in red I would create a simple calculation to do that and place on the Colors card.
if sum([Data]) < 2 then "red" else "black" end
and then change the colours to match red & black.
If this doesn't answer your question can you please supply some more detail or some example data ?
That didn't produce the desired results, but it taught me something new!
Based on your suggestion, I created this calculated field:
IF (AVG([Duration hrs/wk (Adj)])<2) THEN "red" ELSE "black" END
When I place the calculation on the Colors card, it tells me "The calculation can't be applied to a user-defined aggregate."
My goal is to visually distinguish between average values that are below 2.5 and those above 2.5. I think I may need to use a reference line instead...
Thanks for your help!
Remove the calculated field and drag it again in the view.
Does this help?
quoting joe mako
If you are editing a calc field that is already on a shelf, and you get that error, you will have to remove it from the shelf and place it again. What the error is saying is you can not perform an aggregate on an aggregate, so the text on the green 'pill' will change from "SUM" to "AGG" - meaning the aggregation is performed inside of the calculated field.