I have a pie chart in BIRT and about 80 data points. I'm looking to group them in three catagories <17 17-20 and >20. To be more specific I'm trying to make a red yellow green chart.
How can I do this. I tried the grouping function, but it only allows even intervals that I can find.
Thanks,
Buzkie
Best Answer
Use a CASE expression in your query to produce a derived column:
and then you can bind the pie chart in BIRT to the derived column instead of the actual data point value.