Hi all, I'm having troubles setting the colours of the bars in my barchart.
Barchart goes:
On Change of ({@modification age}, {assigned_to_group})
Show Value({Count of @modification age})
The on change of for @modification age has a specified order, which is:
30 days or less
31-60 days
61-90 days
91-120 days
120 days or more
I set it up so that the color highlight conditions are the same as the specified order conditions. I also have it set up to 'Color by Groups'.
The idea is that I want the chart to display:
30 days or less -> green
31-60 days -> light yellow
61-90 days -> dark yellow
91-120 days -> orange
120 days or more -> red
I can't seem to figure out how to make it happen... the closest I got was when it did this:
30 days or less -> blue
31-60 days -> light yellow
61-90 days -> dark yellow
91-120 days -> orange
120 days or more -> orange
I'm likely doing something dumb, but it's driving me mad since there seems to be very little logic here...
shera4111
Barchart goes:
On Change of ({@modification age}, {assigned_to_group})
Show Value({Count of @modification age})
The on change of for @modification age has a specified order, which is:
30 days or less
31-60 days
61-90 days
91-120 days
120 days or more
I set it up so that the color highlight conditions are the same as the specified order conditions. I also have it set up to 'Color by Groups'.
The idea is that I want the chart to display:
30 days or less -> green
31-60 days -> light yellow
61-90 days -> dark yellow
91-120 days -> orange
120 days or more -> red
I can't seem to figure out how to make it happen... the closest I got was when it did this:
30 days or less -> blue
31-60 days -> light yellow
61-90 days -> dark yellow
91-120 days -> orange
120 days or more -> orange
I'm likely doing something dumb, but it's driving me mad since there seems to be very little logic here...
shera4111