nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

plotting cummulative BarChart in BIRT report

Pan · 2013-07-16T05:50:43+00:00

Hello All, I have BIRT prob similer to Pooja's post below. <a data-ipb='nomediaparse'…

Pan

Hello All, I have BIRT prob similer to Pooja's post below.<a data-ipb='nomediaparse' href='http://www.birt-exchange.org/forum/index.php?/topic/29739-how-to-create-cumulative-graphbar-chart-in-birt/'>http://www.birt-exchange.org/forum/index.php?/topic/29739-how-to-create-cumulative-graphbar-chart-in-birt/</a> I will fetch data from ClearQuest. I want to plot 'number of issues' against 'Submit Date' over a period of time. I need cumulative count of issues in y axis against 'Submit date' in x Axis. I want to display different types issues as group against x axis. Ex:We have below table: There are 3 types of issues (Type1, Type2, Type3), count of these 3 types need to be plotted over a period time(Jan, Feb, Mar).(Please refer Table.jpg is attached) Jan Feb **** Count Feb Mar **** Count MarIssue Type1 2 1 2+1 =3 4 3+4 = 7 Issue Type2 3 2 3+2 = 5 1 5+1 = 6 Issue Type3 4 4 4+4=8 2 8+2=10 So i need cumulative chat for above data in BIRT.(Attached the pic of BarChat.jpg below). Please refer the attachments. As per my knowledge Cumulative count functionality is not available with BIRT chart package. I am not able to think about creating cumulative column for y axis. Can any one please help on this. Thank you!

Find more posts tagged with

Comments

kclark

You could create a PGV in the initialize() of your report like this<pre class="_prettyXprint">reportContext.setPersistentGlobalVariable("lastValue", "0")</pre>Then create a bar chart with four series. The first three would be for issue type 1, 2, and 3. Then the fourth you could use an expression similar to this to create the cumulative series as the chart keeps going.<pre class="_prettyXprint">var lastValue = parseInt(reportContext.getPersistentGlobalVariable("lastValue"));var currentValue = data["Summary Field/Issue1"]+data["Summary Field2/Issue2"]+data["Summary Field3/Issue3"]var newValue = currentValue + lastValue;reportContext.setPersistentGlobalVariable("lastValue", newValue.toString());newValue;</pre>In this example I used a data cube for the chart, but it should still work the same for what your trying to do.