Colours In Mini Chart Pie Charts Incorrect

Hi,

The pie mini chart sorts dimensions from largest to smallest on each row of data and then colours from largest to smallest wedge on each row of data. If the relative order of the wedges differs from one row to the next though the colours are not applied consistently to the dimension used on the pie chart.

Take this example, values for A B and C are reversed for the two dimensions (ABC and CBA) and the colour for the A wedge and the C wedge are flipped between the charts:

In the first chart you will see that A is coloured Dark Blue and C is in Green. In the second chart these colours are reversed.

The values in the columns are obtained using set analysis (e.g. sum({<Group={'A'}>}Value)) and the pie doesn't reflect the different values.

If it were possible to provide a sort order for the mini chart it would be possible to sort wedges from largest to smallest value regardless of dimension (so in this instance the CBA chart would show the smallest wedge first) then the colours being applied consistently clockwise around the chart would be fine. This however can't be done as there is no sort option.

Also, it would be possible to create a colour expression that applies the colours in the correct order for the dimension sort order, except that the colour expression is worked out outside of the dimensionality of the chart, so the wedges will always be coloured in the same order regardless of the values of the dimensions.

Attached is a very simple app which demonstrates this issue (from which the screenshot above was taken).

Steve