How to control the order of items in Category X-series in a bar chart
I have a scripted data set which is a java object very similar to a JDBC ResultSet . It has three columns: build, status, and count. The sample data for the data set is as follows:
build_1 New 12
build_2 Existing 9
build_2 New 20
When I designed the bar chart, I specified the series as follows:
Value(Y) Series to be the column 3 (i.e. the count)
Category (X) Series to be the column 1 (i.e. the build)
Option Y Series Grouping to be the column 2 (i.e. the status) and Group Sorting is "Ascending"
In the generated bar graph, the legend items are "Existing" and "New". The trouble for me is that the order of the items in the X-axis in the bar graph is first "build_2" and then "build_1", which does not respect the order in my data set (first "build_1" and then "build_2"). The cause for this is probably because the "build_1" does not have an entry for the first item in the legend (i.e. "Existing").
I am in urgent to solve this problem for our reporting system that is built on Eclipse BIRT. Any helps and comments on this issue are appreciated.
