Birt chart: Histograms with broken axis and columns

spulci

Hi,<br />
<br />
we need to realize histograms where one or more axis are "broken", i.e. value range on this axis may have a "compressed" interval to broke the scale (not all values are represented).<br />
<br />
To have an idea please look at the image below:<br />
<br />
<img src='http://andypope.info/charts/brokencol.gif' alt='Posted Image' class='bbc_img' /><br />
<br />
Is there any option in birt designer to obtain a similar result like that one? Or could we use some tricks with Rhino JS and other elements to achieve this goal?<br />
<br />
Thanks a lot<br />
<br />
Simone

kclark

Sorry for the slow reply, I've attached one possible way of doing this. I placed two charts in a grid. On the first chart for the y axis series I used the following script.<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>if(row["COUNTRYTOTAL"] > 2000000) {
2000000;
}else{
row["COUNTRYTOTAL"]
}</pre>
<br />
Then I set the max of the y axis to 2000000. Then in the second chart that is on top I checked to see if each series is greater than 2000000 using this<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
if(row["COUNTRYTOTAL"] < 2500000) {
0;
}else{
row["COUNTRYTOTAL"]
}</pre>
<br />
And I set the scale minimum to 2500000.<br />
<br />