Grouping by column name

Hi all, 
 
I am working on a chart with the following type of data: 
 
Camp1 - Sent: 50, Read: 10 
Camp2 - Sent: 90, Read: 20 
Camp3 - Sent: 110, Read: 50 
 
What I need to do is create a "comparative chart" that is Category grouped by the column names (Sent and Read). 
 
The chart should display something like this: 
(done in ms paint

<a class='bbc_url' href='http://63.253.152.110:8082/images/birt/comparative.jpg'>http://63.253.152.110:8082/images/birt/comparative.jpg</a>) 
 
Sent was 50 for camp1, 90 for camp2, 110 for camp3 
 
Read was 10 for camp1, 20 for camp2, 50 for camp3 
 
The way I have it working now, it shows: 
(<a class='bbc_url' href='http://63.253.152.110:8082/images/birt/comparative_current.jpg'>http://63.253.152.110:8082/images/birt/comparative_current.jpg</a>) 
Camp1 was 50 sent, 10 read 
 
Camp2 was 90 sent, 20 read 
 
Camp3 was 110 sent, 50 read 
 
This would seem to be an easy task, but there doesnt seem to be any documentation that I could find to show how it's done. 
Any ideas would be appreciated. 
 
Thanks, 
 
Dragos

Find more posts tagged with

Comments

Asmrani

what exactly are you trying to do

sort to have the order by the read column?

mwilliams

Hi Dragos,

If I'm understanding what you want correctly, I think you'll have to just set up 2 charts next to each other. One for sent and one for read.

dragos

Hi asmrani, 
 
The second link i posted - <a class='bbc_url' href='http://63.253.152.110:8082/images/birt/comparative_current.jpg'>http://63.253.152.110:8082/images/birt/comparative_current.jpg</a>, shows data being grouped by the campaign name (sorry the X axis labels were accidentally cropped out). 
What I need to do is group the same info by the type (ie. emails sent, emails read etc.) 
All of this info should be in one chart, unfortunately parallel charts would not work out for me.