Pie Chart: Comparing two columns

I have a column which displays all tests result for a project in the format

Passing|Failing|ID|Date
50 20 1 1/05/2012
I want a pie chart that compares the Passing and Total amounts for a given project.

Is this possible?

Find more posts tagged with

Comments

CBR

So you want a pie having two slices (one for passed, one for failed) for each project in your dataset? Do you want to show all projects or a specific project (several pies or only a single pie).

The current dataset can not be used to generate such a pie because BIRT assumes that you a single row for each value.
It would be easy if the dataset looked like follows:

Passed or fail | Amount | Project name
passed, 200, Projekt x
failed, 20, Projekt x

Having such a dataset one can generate a pie chart using column passed or fail as Category series and amount as slice size definition. Project name can be used as grouping condition to generate one pie for each project in the dataset (can be omitted if dataset only contains one project at a time)