I want to display how many items are ordered before an event starts. So I got a simple data-model with two fields: DAYS_UNTIL_START and NUMBER showing the amount at the Special day-combination. I created a chart and added color (< -21 green, < -7 yellow, red) depending on the dimension to Highlight what I want to say. This is the result:
this Looks not bad, but there is one problem: the bars are overlaying each other! You can see this ad -8 (yellow) and -7 (red). To solve this I created another chart using class() to Cluster the data for an overall view. This is the result:
I grouped the data to a 5-day-corridor using class() to avoid overlaying bars. My problem with this chart are the wrong colors. It's too much red
So now I got two Problems. Can anybody help me solving one of These or even both?