## Question

## Order piles within columns in report definition chart

Hi,

Using the piled up column chart associated with a report definition rule :

One of request's elements is a function grouping the retrieved data by urgency (GroupUrgency) and returning a string, namely 'P<20', 'P<40' or 'P>40'.

Data is ordered by "Agent" first and then by "Urgency" (min value to max value) :

We then use a conditionnal coloring on the GroupUrgency result for the piled up column chart and get the following result :

However, we wish to order the piles in each column as follow : green(P<20) at the bottom, then orange (P<40) and finally red (P>40) at the top.

For information, when switching the ordering to "Max value to Min Value" we get : orange (P<40) on top, green(P<20) in the middle and red (P>40) at the bottom.

Any idea(s) on how this ordering works, how to influence it and obtain the desired result ?

Thanks.

I haven't seen any specific documentation on this particular functionality, but my impression from the stacked column charts I've worked with is that the order of the stack is the same as the order of the legend, and the order of the legend is the order that the series are added to the chart. Are you seeing something different from this?