Building a Stacked Series Chart from Multiple Crosstabs

Hello,
 
I've been trying to figure out a way to accomplish this for a while, but am running out of ideas to try. I have attached an example that relies on a CSV flat file in C:\TEMP. The basic premise is that I want to take the data from the three crosstabs and combine them into a single chart, where each crosstab's data is a series. As you can see, the three crosstabs all have the same group (Day of Week), with different segments of a Turnaround Time.
 
Each crosstab has its own set of filters, so I can't just build one crosstab that includes all of the filters and then chart from that.
 
I rendered an example in Excel for what I want the final chart to look like. 
 
How can I accomplish this in BIRT? Thanks!
 
EDIT: Wrong CSV attachment posted originally....

Find more posts tagged with

Comments

micajblock

What version of BIRT are you using? I have an example using commercial BIRT and Data Objects.

hoyt

4.4.2

micajblock

Attached is an example that takes 2 crosstabs with different filters and creates a 3rd crosstab using the data from the first 2. The idea in general is to store the data from the first 2 crosstabs in a global variable, then use that to create a scripted data source. You can use that data source to create a chart (or in the case of the example a crosstab).
 
P.S. I am not a big fan of stacked bar charts as visually it is very hard to compare the sizes of each stack in the bar. Kind of defeats the purpose of the bar chart.

hoyt

Thanks. That's one of the options I tried to do (I was trying to store the values from each row in a hashmap, then pushing the hashmap into an array). I was struggling to get to the value measure (the average in my example). It doesn't look like your crosstab has a computed metric, do these behave differently?
 
I'll take a look at this in more detail later as well - just briefly looked at the rptdesign file. Thanks!

micajblock

I think it should work with the binding name.