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?
I guess your observation is correct : the order of the legend seems connected to the order of the stacks; Green at the bottom then orange and finally red.
My first guess was that the order of these was probably linked to the quantities represented by each stack : the one with the most elements first (green) followed by red and orange. However, if I switch the order criteria to its contrary, the orange (the one with the least amount of values) stays on top, whereas I was expecting it to be at the bottom.
My second guess led me to believe the order might be based on the string I use for the grouping ('P<20'...). Thus I changed it for a simple 'A', 'B' or 'C' return :
Switching the ordering again gives me : C, A, B. So that's not it either.
Changing the order in which I enter the conditionnal coloring for the legend doesn't change a thing either : I always get "C, A, B " or "A,C,B".
After a few tests, my understanding is that the order of the stack in each column is actually based on the order of the stacks of the first column.
Meaning that, if the first column doesn't have any elements for one the string values (here orange P<40), it only applies the order to the other two values (green P<20 and red P>40) and only once it encounters the third one (orange P<40) does it include it, just adding it at the end but the order already happened for the previous ones. Therefore, I can't obtain the order I want unless my first column has elements for each of the string values.
Does that seem like a possible hypothesis to you ? Any idea(s) on how to get around this mode of operation ?
Ordering by "GroupUrgency" first then "Agent". Chart is ok but that messes up my table view by grouping by 'P<20'...etc. first.
Ordering by "GroupUrgency" first then "Agent" but display the result as a matrix for the table view. This way I get the desired chart but a different table.
My goal was to obtain the chart I first described and a table first grouped by "Agent" then by "Group Urgency" as I implemented it in the first place. My understanding is that I can't get both at the same time. Correct ?