nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Pie chart with summarized data from 3 different columns

sonysunny4u

Hello, 
 This i kind of basic question but i'm new to BIRT (coming from Business objects back groud). so please bare with my simple questions. I do have below scenario.
 
 
ZipCode Total Population Male Population Female Popuation
 
49006 525000 324000 201000
 
 
I was able to add zipcode as parameter selection but want pie chart with male and female population displayed only in one pie chart.
 
advanced thanks for your help.

Find more posts tagged with

Comments

mwilliams

You could transform your data to be in the form of: Gender Population Male 324000 Female 201000 That would obviously make it easier. Or you could create the pie chart for one of the values and then just add the other through script with something like in this old devShare post: <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/779-adding-an-extra-slice-to-a-pie-chart/'>http://developer.actuate.com/community/forum/index.php?/files/file/779-adding-an-extra-slice-to-a-pie-chart/</a>

sonysunny4u

you are concatenating but what i'm look with pie chart with % male and female population out off total population. what is the easiest approach to convert columns in rows in BIRT?

sonysunny4u

never mind, got it. used scripting and join data set. 
 
thanks

mwilliams

The point of the devshare link was to show how to add a slice. I created a pie chart with one column of your data as the slice size field. Then, I took the value from the other column and added it to the pie chart. This was done without doing any modifications to the data. If you're satisfied with what you have, that's good enough for me. If you'd like to see an example of adding the slice in your exact situation, let me know your BIRT version.