BAR CHART MULTIPLE X-AXIS - BIRT

Hi,
 
Could someone advise me on the below point ?
 
This is related to BAR chart X-Axis.
 
I am trying to create two x-axis but struggling to do so.
 
Please find attached report.
 
In this report, when we run it against "UK" it will show country and city information on x axis.
 
But "UK" is getting repeated below every city, I want it to be like group.
 
which means the output should show -
 
"cowes" "Liverpool" "London" "Manchester"
 "UK"
 
So for all cities it should show one time "UK"
 
BIRT version I am using is : 4.4.2
 
Is it possible.
 
Thanks in Advance !!!

Find more posts tagged with

Comments

Clement Wong

Sorry, buy there was no attached report design. Can you please attach so that we can review it?

RRK

Sorry for this.
 
Please find attached report design.

Clement Wong

Maybe I'm oversimplifying, but can you just put a Data Item to display the Parameter "Country" under the Chart (and change the Category X Series back to row["CITY"])? See the attached modified version (1) of your report.
 
Another method is to use the X-Axis Title as the place holder for the group name. See the attached modified version (2) of your report. The onRender event of the Chart was modified as follows:
 
function beforeDrawAxisTitle( axis, label, icsc ) 
{ 
importPackage(Packages.org.eclipse.birt.chart.model.attribute); 
if(axis.getType() == AxisType.TEXT_LITERAL) 
 { 
 label.getCaption().setValue(icsc.getExternalContext().getScriptable().getParameterValue("Country")); 
 } 
}

RRK

Hi,
 
Thanks for your quick reply!!!
 
Could you please let me know if we have more then one country how will we modify our report ?
 
Please find attached report.
 
In this case countries selection can be one country(eg : USA), or can be two countries (France,USA) or can be more then two (depends up on user) so in this case we cannot have a label at bottom, please correct me if I am wrong.

Clement Wong

Oh, your attached sample design only had one country. So what you actually want is two level axis labels for one or more groups.
 
With OS BIRT, it is possible, but it may not be elegant. Checkout <a data-ipb='nomediaparse' href='https://www.eclipse.org/forums/index.php?t=msg&th=237365&goto=720570&#msg_720570'>this thread</a> for an example which you can modify. You may want use ":" in between Country and City and use JavaScript's string split (for example, yourStr.split(":")[0] to get the first element).
 
With commercial BIRT, since it's HTML5 charts based on HighCharts, it's easier to manipulate and add two level axis labels in and look nicer.

RRK

Thanks for your reply!!!

I went through the thread earlier as well that's the reason I was trying it by placing "City"+ "\n" + "Country" at expression level.
 
But got stuck after that.
 
Could I request you to please create a chart in commercial birt and add two levels for "City" and "Country" using sample database?

Clement Wong

Attached is a sample using commercial BIRT (iHub 3.1) that shows two x-axis or grouped x-axis using HTML5 charts.
 
1. Changed the Category X Axis to: row["COUNTRY"] +":"+ row["STATE"]
We will later parse out the two levels using JavaScript's split function.
 
2. Modified beforeDrawAxis event to change height of chart to make room for 2nd x-axis. Parsed out the subgroup (in example it is STATE) and change the labels.
 
3. Added a script in the Chart Area > Load event to build out the new parent group for the 2nd x-axis, built out the tick marks to separate the parent group, added the 2nd x-axis and then formated the labels by centering them.

RRK

Hi Clement,
 
Thanks a lot for this solution.
 
This is what I was looking for.
 
Please let me know from where we can download the commercial birt (iHub 3.1) ?

Clement Wong

That's good to hear!
 
You can download the commercial designer (formerly BIRT Designer Professional, now Analytics Designer) here @
<a data-ipb='nomediaparse' href='http://www.actuate.com/resources/product-downloads/'>http://www.actuate.com/resources/product-downloads/</a>

RRK

Thanks Clement for your time!!!

remember_me

Hi. I don't see any attachment of this example. Can you please update the link?