Community
Participate
Working Groups
Build Identifier: BIRT Engine version 2.5.1.v20090916 Stacked bar chart with multiple values. The optional Y series grouping is a string value but data sorting is on an integer value descending. The values in the bar are not sorted by volume, there appears to be some sort of ordering being applied, but it is not accurate. Reproducible: Always Steps to Reproduce: See attachement
Created attachment 158961 [details] Attached report show the problem
Created attachment 158962 [details] Image of report The attached image shows that for the Aug-08 bar, the first 7 entries are sorted correctly, but then the value 3217 appears out of order. What can be seen is that the entries seem to be in the same order for each bar, although they should be sorted differently.
(In reply to comment #2) > Created an attachment (id=158962) [details] > Image of report > > The attached image shows that for the Aug-08 bar, the first 7 entries are > sorted correctly, but then the value 3217 appears out of order. > > What can be seen is that the entries seem to be in the same order for each bar, > although they should be sorted differently. Currently sorting key of optional grouping is based on aggregation values. That means the aggregated values are used to determine the order, rather than single value in each category. In this case 3210+17 is less than other values such as 1622+1622. This is expected behavior, but I agree the values in each category should be sorted respectively. However this is difficult to implement this behavior, so defer to future to see if feasible.
Although I'm aware that this bug-report has not been visited for a while I really would like to see any progress on this as there are two major releases in between (I'm using Version: 4.3.0.v201306051647-8F8y79FT0z0-U-C15CS3sN Build id: v20130611-1045). My proposal would be to sort the legend according the aggregated values and the stacked columns according the column specific sort order.