<p>Hi All,</p>
<p> </p>
<p>I am using BIRT RCP 4.3.1</p>
<p> </p>
<p>I need to create a report (preferable side-by-side/stacked bar chart), which shows the on-boarding status of different tool (each tool_set have sub divisions w.r.t. branch) sets in various application for each month.</p>
<p> </p>
<p>Below is a sample data:-</p>
<p> </p>
<div>APPLICATION,TOOL_SET,FOR_MONTH,COMPLETION_PCT,BRANCH</div>
<div>APP1,TOOL1,01/01/2016,100,APPLICATION</div>
<div>APP1,TOOL1,01/01/2016,100,DB</div>
<div>APP1,TOOL2,01/01/2016,50,APPLICATION</div>
<div>APP1,TOOL2,01/01/2016,10,DB</div>
<div>APP2,TOOL1,01/02/2016,10,APPLICATION</div>
<div>APP2,TOOL1,01/03/2016,40,APPLICATION</div>
<div>APP2,TOOL1,01/04/2016,80,APPLICATION</div>
<div>APP2,TOOL1,01/04/2016,10,DB</div>
<div>APP2,TOOL1,01/04/2016,30,UI</div>
<div>APP2,TOOL1,01/01/2016,0,APPLICATION</div>
<div> </div>
<div>Hence the report would have , for application APP1,tool_set TOOL1, For_month January, the bar should have a breakup of branch 100(Application) and 100(DB)</div>
<div> </div>
<div>similarly for application APP2,tool_set TOOL1, For_month April, the bar should have a breakup of branch 80(Application), 10(DB) and 30(UI)</div>
<div> </div>
<div>The report should have %completion on the y-axis and applications on x-axis.</div>
<div> </div>
<div>The issue comes where we are trying to represent/group both for_month and branch (no option available in BIRT)</div>
<div> </div>
<div>Can this at all be represented? any suggestions please</div>
