chart with multiple series based on group

<p>hi, i have a data set like below. and colGroup is being used group the table. Can you please give me an eg on how to create two line series (first series with Grp1- 2,6,10 and second series with Grp2-1,5,9).</p>
<p> </p>
<div>colX colY colGroup</div>
<div>1/1/16 2 Grp1</div>
<div>2/1/16 6 Grp1<span> </span></div>
<div>3/1/16 10 Grp1</div>
<div>1/1/16 1 Grp2</div>
<div>2/1/16 5 Grp2</div>
<div>3/1/16 9 Grp2</div>
<div> </div>
<div> </div>
<div>thanks for your help.</div>
<div> </div>
<div>regards,</div>
<div>suresh</div>

Find more posts tagged with

Comments

pricher

<p>Hi Suresh,</p>
<p> </p>
<p>These are the settings you need in the Chart Wizard:</p>
<p>

suresh@anumolu

<p>Thanks Pierre Richer. Is there any snippet which i can achieve it in BIRT DEAPI using SeriesGrouping or any other option? </p>
<p> </p>
<p> </p>

pricher

<p>Hi Suresh,</p>
<p> </p>
<p>If you want to do this in code, your best option is to start from one of the examples provided in BIRT Designer. (NB: the examples were removed starting with BIRT 4.5.0. If you are running this version, you can download a previous version...)</p>
<p> </p>
<p>To find the examples, go to Window --> Show View --> Other... From the Show View dialog, choose Report and Chart Design --> Chart Examples:</p>
<p>

suresh@anumolu

<p>Thanks, I dont have access to that part for chart examples in my designer. It would be helpful if you can send me that small part how the the Optional Y Series Grouping being set in api. </p>
<p> </p>
<p>I am not sure the following </p>
<p><span style="color:rgb(64,64,64);font-family:'Courier New', Courier, mono;font-size:13.3333px;"> SeriesGrouping groupingY2 = sdY2.getGrouping( );</span></p>
<div style="color:rgb(64,64,64);font-family:'Courier New', Courier, mono;font-size:13.3333px;margin:1pt 0pt 0pt 42.5197pt;">groupingY2.setEnabled( <span style="color:rgb(127,63,106);font-weight:bold;">true</span> );</div>
<div style="color:rgb(64,64,64);font-family:'Courier New', Courier, mono;font-size:13.3333px;margin:1pt 0pt 0pt 42.5197pt;">groupingY2.setAggregateExpression( <span style="color:rgb(42,0,255);">"Average"</span> );</div>
<p>thanks for your help.</p>

pricher

<p>Coding the Chart Engine API is not my area of expertise. Per your request, I am sending you the java source code mentioned above.</p>
<p> </p>
<p>However, if you have more questions regarding its implementation, I suggest you start a new thread indicating you need help with the API.</p>
<p> </p>
<p>Good luck!</p>
<p> </p>
<p>P.</p>