Bonjour<br />
<br />
J'ai un Data set de type<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
type value date (1st of Month)
String Float Date
AP 0.27 2009-01-01
EP 0.30 2009-01-01
AP 0.19 2009-02-01
AS 0.15 2009-02-01
...
</pre>
<br />
Note Each month dont' contains every <em class='bbc'>type</em><br />
<br />
I want draw a Percent Stacked Bar Chart.<br />
X serie : Date,<br />
Y Serie Value by Type<br />
How to manipulate data to draw the chart ?<br />
I try with an boolean expression with the expression builder :<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
if(row["type"]=="AP"){
return row["value"];
} else {
return 0;
}
</pre>
But Birt don't recognize the expression <blockquote class='ipsBlockquote' ><p>The data type of if("AP".equalsTo(row["type"])){<br />
return row["value"];<br />
}else {<br />
return 0;<br />
} is incompatible with Bar Series, please correct the expression.<br /></p></blockquote>
(try to "AP".equalsTo(row["type"])<br />
<br />
Any piece of Advice ?<br />
<br />
F.P.
