Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Optional grouping breaking pie chart
Migrateduser
I have a pie chart in my report that contains a legend that must be displayed in a certain way. This is a requirement from the customer.
It is not alphabetical and there is no natural sort order, so in my database I created a numeric "rank" field and gave each entry a number. There are 5 entries.
If I just use the data field as my category grouping, the pie chart looks correct, but BIRT wants to display the legend in alphabetical order. But when I try to use my rank field as the optional group, the pie chart splits up, basically making a small pie chart for each entry in the legend. In other words it breaks out into 5 small circles, each a solid color (each pie chart contains 100% of one entry).
When I was using a bar chart I did not have this issue - I did it exactly the way I describe above. But another requirement from the customer is to change from the bar chart to the pie chart.
I have also tried combining my data and rank fields together, and just displaying the data portion by using this as my optional grouping (this is what I was using in the bar chart):
row["RANK_FIELD"].substr(2,1)+row["DATA_FIELD"]
but I get the same problem.
Any ideas? I'm running BIRT 11.0.3, Service Pack 2.
Find more posts tagged with
Comments
There are no comments yet