Legend sort order is not following the sort order configure by the user.
App has the "Sort" field to apply an order. Each value is 10 for C, 20 for A and 30 for B.
Apply this field for a sort order.
See the attached sample App.
Chart legend shows the order A->B->C. The order is expected to be C->A->B
The legend data is always sorted alpha-numeric - descending and currently there is no setting to change this behavior
This is an intended product behavior at the moment.
There are two cases to consider here, "Auto coloring" and "Color by Dimension".
- Auto coloring: We use an "old" way to color things and create a legend, using the data in the chart. This leads to the legend being sorted the same as the input data, which can be confusing when having multiple dimensions. In thisr case, "C" (second dim) does not have data in "1" (first dim) so in the resulting table "C" will always be found last as far as the legend is concerned.
- Custom->By dimension: As we now allow coloring by any dimension we add additional data AND we fetch the legend data in a separate engine call. This legend data is always sorted alpha-numeric - descending and has currently no settings to change this.
The new API engine allows us to get the legend always sorted alphabetically.