Chart - how to get column value from Container and pass it to title

hedgehog · 2017-06-28T08:53:29+00:00

Hello, I have data grouped by STATION. For each group a chart is created with data "Inherit data from container". I need to change the title for the chart and show the STATION. I know how to change the title function…

hedgehog

Hello,
 
I have data grouped by STATION. For each group a chart is created with data "Inherit data from container".
 
I need to change the title for the chart and show the STATION. I know how to change the title
 function beforeGeneration(chart, icsc) { 
chart.getTitle().getLabel().getCaption().setValue("...."); 
}
but I don't know how to pass value from column STATION.
 
Thank you very much in advance,
Lucy

Find more posts tagged with

Comments

Clement Wong

We can get the value category and the values of the series in the afterDataSetFilled event. So then we save it, and use that variable in the beforeGeneration event to set the title.
 
Example:
<pre class="_prettyXprint _lang-">
function afterDataSetFilled( series, dataSet, icsc )
{
if (series.getSeriesIdentifier() == ""){ // Category (not a series like 'Series 1'
myTitle = dataSet.getValues()[0];
}

}

function beforeGeneration(chart, icsc) {
chart.getTitle().getLabel().getCaption().setValue(myTitle);
}
</pre>

hedgehog

Hi,
 
thanks for the reply. With series.getSeriesIdentifier() == "" 
I got the values from x-axis (Category). But what I need is the following: The chart is binded to data model, which contains column STATION, STAMP and INDICATOR. In the graph I display the STAMP (x-axis) and INDICATOR (y-axis). And in the title I need to have STATION.
Is it possible?
 
Thanks,
Lucy

Clement Wong

In the future, please include an example of what you've tried and what you are trying to achieve. Data model? BTW, are you using commercial BIRT?
 
If the data is not in defined for the chart, you'll need to store it and retrieve it. I'm sure there are other ways, but here's one:
 
1. In the beforeFactory event of the report, create a Java hashmap, and store it in a BIRT persistent global variable:
<pre class="_prettyXprint _lang-">
importPackage(Packages.java.util);
reportContext.setPersistentGlobalVariable("pgvDataHashMap", new HashMap());
</pre>
2. In the Chart's Category Definition under Edit Chart > Select Data, modify the expression to save the other values. For example, if your original category was row["Status Group"], then change it to:
<pre class="_prettyXprint _lang-">
var myDataHashMap = reportContext.getPersistentGlobalVariable("pgvDataHashMap");
myDataHashMap.put (row["Status Group"], row["STATION"]);
reportContext.setPersistentGlobalVariable("pgvDataHashMap", myDataHashMap);

row["Status Group"];
</pre>
3. In the afterDataSetFilled event, change my previous example of setting the myTitle variable to:
<pre class="_prettyXprint">
myTitle = icsc.getExternalContext().getScriptable().getPersistentGlobalVariable("pgvDataHashMap").get (dataSet.getValues()[0]);</pre>
This method works in my environment. Sorry, I will be out of the office and will not be able to reply until after Monday, July 10th.