Scatter chart with multiple optional grouping

Hi,
 
I have a requirement, where I need to display values in x axis and % share in y axis using a scatter chart. I also need to display the product name on top of each scatter point on the graph. I achieved this by dropping the product name in to optional y grouping, Now I need to get the same report for every single shop in my area. So I need to create a grouping based on shops and also based on product ( to display the product names on the graph). I am not sure how to do this. Kindly help.
 
Basically what I need is to have two groupings, or an option of displaying the product name without using optional y grouping.
 
Regards,

Find more posts tagged with

Comments

Clement Wong

The easy way whether it's open source or commercial BIRT is create a table with a group based on the shops. In the group header, you can add your chart so that it will create one chart per shop.
 
You can use scripting to display product name, or you can put BOTH charts in the cell, and use the report item's Visibility property to Hide the item based on the report parameter selected.
 
Should you require more assistance, please include sample data, and examples of the charts required.

piramanayagam.td

Clement Wong

You didn't mention what version of BIRT or if you're using open source BIRT or commercial BIRT. So the attached example design, created with OS BIRT 4.5.0, contains on the first page, a scatter plot of all products and all shops.
 
On the subsequent pages, each page contains a scatter plot for each shop's products. The table has a group, which is segmented by the "shop name".
 
There are two charts on the page to illustrate the different techniques used. The first chart's data points to the Data Set, and there is Filter -- row["shop name"] Equal to row._outer["shop name"].
 
The second chart's data is inherited from its container, which is the grouped table. The default option "Inherit Columns and Groups" is selected.
 
All charts have labels (in your case "product name") above their scatter plot point. This is achieved in the UI options: Format Chart > Series > Value (Y) Series > Labels. Under Values, remove "Value Data" and add "Category Data".

piramanayagam.td

Thanks a lot for your effort in creating an example. I am using OS BIRT version 3.2.23.
 
In your example you have used x axis as product name, but I need to use industry value (it might not be 100 all the time, the value might change according to product) in x axis and in y axis, I need to use (mycomp value/industry value)* 100 = mycomp share.
 
and in the label I need to display the name of the product rather than value data or category data, is this possible?
 
Thanks a lot once again.
 
Regards,

Clement Wong

It's certainly possible to meet all of your requirements. For the labels, you would just select and add "Value Series Name" instead of "Category Data".
 
The attached example changes your data so that we have different industry values because having all 100s in the sample data was confusing, has the Industry Value in the X-Axis as categories, Y-Axis is the Comp Share, and the labels with Product Names.

piramanayagam.td

Thanks a lot for your help. It is working fine now.