Home
Analytics
Percentage Pie Chart
Kia
<span style='font-family: Courier New'>I am trying to simply create pie charts to show percentage two column values:<br />
<br />
RED
Blue----Total
chart<br />
================================<br />
5
5
10
50%<br />
3
7
10
70%<br />
10
20
30
67%<br />
10
40
50
80%<br />
===================================<br />
28
72
100
72%<br />
<br />
<br />
I am not sure if this is possible with BIRT. I appreciate any pointer.</span>
Find more posts tagged with
Comments
thuston
I can't think how to do it.
You need to transform your data to something usable.
BIRT can then easily calculate everything else.
Type---Val---Group
===================
Red----5
1
Blue---5
1
Red----3
2
Blue---7
2
Red----10----3
Blue---20----3
Red----10----4
Blue---40----4
Kia
<span style='font-family: Courier New'>Thanks for the reply. I don't mind slicing and dicing the data whichever way as long as I have a trivial two-value percentage pie chart.<br />
<br />
let's really simplify it: if I have a two-liner grid:<br />
<br />
<br />
Red---Blue<br />
==========<br />
3
7--<br />
<br />
<br />
how can I show a pie chart with 70% blue and 30 percent red?</span>
thuston
That's the hard part.
I don't see any way to treat separate columns as Pie categories.
That one row needs to become two rows (one with Red value and the Other with Blue).
Kia
Someone gotta ask the hard question
The thing that bugs me the most is that this is easily done using a Meter but not Pie chart.
Being a huge fan of BIRT, I'd love to see it having another pie-chart for percentages as I think it would be the most useful.
Requirement would be very simple:
- allow selection of multiple independent values (from data or static)
- allow input of value for 100% (if not present the total of all values represent 100%)
- Plot the same way as the current pie chart .
Thanks again for your help Thuston...
akram720
oh great.. you solve the problem
MaxG
<blockquote class='ipsBlockquote' data-author="'akram720'" data-cid="69127" data-time="1286453105" data-date="07 October 2010 - 05:05 AM"><p>
oh great.. you solve the problem<br /></p></blockquote>
<br />
Hi,<br />
I have got the same problem now
.<br />
So im realy interested in this solution
.<br />
<br />
@thuston
: is there still no other way than chnging this data ?<br />
and if there is no way... how can i change them ?<br />
<br />
Thx, Max<br />
<br />
Ok, I'm trying to get a second Data Set for the Pie Chart now.