Sum of Total from Percent Stacked Bar Chart

Dear All,

I've been struggling for a while to come up with an easy way to sum the values in a percent stacked bar chart and display them on the x axis.

I'm using BIRT 2.3.2 (thanks to Maximo) and I have a Percent Stacked Bar Chart.

My thoughts are to use the onRender method and start with adding the series values and storing them as another value. That's where I start to fall a bit short. I don't know how to identify the series values for each row nor how to add them together.

Any help would be really aprreciated.

I've attached two pictures to give you an idea of what I'd like to achieve. The first is the setup of my chart and the second shows two charts. Appendix A is what I have, Appendix B is what I would like to have.

Thanks

Find more posts tagged with

Comments

wwilliams

Try modifying your Category (x) series in the expression builder
e.g. row["Month"] +"\r\n" + row["TotPercent"];
This will put your total under your month

DavidRiep

You know sometimes the simplist solution is the best! I can't believe I didn't even think about that, I was too busy trying to script it!! Good work! 
 
<blockquote class='ipsBlockquote' data-author="'wwilliams'" data-cid="115376" data-time="1364223867" data-date="25 March 2013 - 08:04 AM">
Try modifying your Category (x) series in the expression builder 
e.g. row["Month"] +"\r\n" + row["TotPercent"]; 
This will put your total under your month </blockquote>

DavidRiep

Ok maybe I spoke too soon on this because I've added an aggregated column to the binding and now I get an error. 
 
Any other suggestions please <img src='http://www.birt-exchange.org/org/forum/public/style_emoticons/default/smile.gif' alt='Posted Image' class='bbc_img' /> 
 
Thanks
 
<blockquote class="ipsBlockquote" data-author="'DavidRiep'" data-cid="115404" data-date="26 March 2013 - 12:37 AM" data-time="1364287056">You know sometimes the simplist solution is the best! I can't believe I didn't even think about that, I was too busy trying to script it!! Good work!</blockquote>