Hi all, I have a problem where I want to change the color of the measures separately. Please see the chart below. I want to set all triangles as red if they are above the horizontal line and green if they are below the horizontal line. I want the color of the horizontal line to be red. Right now the line is green. My color expression is the following:
You can see that the one red triangle below. The corresponding segment of the horizontal line is also red. How can I express the color so that the entire horizontal line is red, and that all triangles above the line is red and all triangles below it is green?
Yes, it's also an improvement we have. The difference here compared to other charts is that if you use one axis on each side it will be a bit trickier to draw the reference line without interrupting the axis values.
For this scenario, would not a bar chart work together with a reference line? You could color the bars depending on if they are above or below the reference line (which you could control the color of). Or is it a requirement that glyphs are used to represent the data?