Grouping a chart in BIRT

Hi,

Just wondering if it is possible to group a bar chart in BIRT, what I am trying to do is create the same bar chart for multiple measures. I need y axis to be my actual figures for the measure, the x axis is a list of locations. Now how and where do I state the bar chart needs to be grouped by MeasureName. Also, if this is possible, how do I define a bookmark to the group (like you can do on tables) so I can pull back the relevant chart via a hyperlink that is displayed on the mashboard?

Any help would be much appreciated. I appear to be at a complete dead end.

Regards

Sonny

Find more posts tagged with

Comments

mwilliams

Sonny,

Can you explain this a little more? Maybe show pictures of what you mean.

sbrar

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="77305" data-time="1305900464" data-date="20 May 2011 - 07:07 AM">
Sonny, 
 
Can you explain this a little more? Maybe show pictures of what you mean. </blockquote>
 
 
Hi Michael, 
 
Attached is an example of the output I would like. 
 
I would also require a bookmark on the MeasureName that allows me to reference the relevant table. 
 
I have more locations than shown in the atatched example but only require the Top 10 performing ones to be returned. 
 
If you need more information please let me know. 
 
Regards 
 
Sonny

mwilliams

Ok. I think I might understand. If you have an outer table or list that lists the different "measures", then you can embed a chart into the table and either use filters or the dataSet parameter binding on the binding tab to limit the locations in the chart. You can then create a bookmark on the measure name in the outer table that you can link to. Let me know if I'm understanding correctly now.

sbrar

Hi Michael,

Thank you for your reply.

I kind of get what you are saying. I attempted your suggestion by:

1. creating a table with a group and bookmark of 'MeasureName'
2. embedded a chart in this group with x axis consisting of 'LocationName' and y axis consisting of 'actual'
3. on my table I added a filter stating 'Actual' equal to Top n (where n is 10)

This did not return the correct output unfortunately. It returned charts with 1 location per chart in a very large list of charts. And this only returned a list for 1 measure of of 20 or so I have.

Any ideas about where I am going wrong?

Regards

Sonny

mwilliams

Can you send me a csv file if your data? Or if you can't send me actual data, can you make a csv file of fake data that is just like yours that I can work with? Thanks! Also, let me know your BIRT version.

sbrar

Hi Michael,

Please find attached some fake data. It has the 3 columns needed to do this - it just has a list of 20 or so countries with 'actual' figures for 3 measures. What I am after is bar charts produced showing the top 10 performing locations for each of these measures in descending order(resulting in 3 bar charts). Each with a unique bookmark on the MeasureID that I can uniquely use to reference each chart in a hyperlink.

If you can crack this then I should be able to apply this to my real data that I hold as the principle would be the same.

Really appreciate you looking at this for me, most kind.

The BIRT version I have is 3.4.2.

Regards

Sonny

mwilliams

This uses your csv file data and does what I think you're wanting. I left the detail row in to show the data that the chart uses so that you can double check the top 10 for each measure.

sbrar

Hi Michael, this is great, just what I am after...thank you very much for your assistance

mwilliams

Not a problem. Let us know whenever you have questions!