Pie chart: grouping less significant results

[Pedja]

Hi,

 

I have a query that returns top 40 results based on some criteria, and they are sorted by percentage, something like this:

 

30%

18%

12%

12%

5%

.

.

.

.

 

The pie chart shows all 40, and it is very unreadable. Is it possible to set the chart to show only results >10% (or top 5 results), and to group all the other results to one pie slice ("Other", for example) with the sum of all of their values as the slice value? I could do this in my query, but I'm interested if this is possible with JFreeChart?

 

Thanks,

Pedja

[fcgb87]

 Hi,

I'm dealing with the same problem.

Did you find any way to solve this ?

 

You said you could do this in your query, i don't really see how , because with the LIMIT clause, you would lose the real 100%-total and your pie chart will be wrong.

Thanks,

 

[svenn]

You could do it in a query with a union. One query would get all you seporate values and one query would get your other bucket.