If you are unable to create a new account, please email support@bspsoftware.com

 

Can't figure out what goes in series, x and y axis for a bar chart - cognos 8

Started by swathika, 11 Jun 2012 06:42:00 PM

Previous topic - Next topic

swathika

Hi,

I am a beginner level reportnet user and I am trying to figure out how to do a 100% stacked bar chart -

here is my simplified data -

policy #   score1   score2   score3
A   3   3   1
B   3   2   1
C   1   2   3
D   1   3   2
summary   count of 3s   count of 3s   count of 3s
summary   count of 2s   count of 2s   count of 2s
summary   count of 1s   count of 1s   count of 1s


expected bar graph output -

3 horizoantal bars one each for score1, score 2 and score 3
each bar sectioned with color coding of scores.
for example bar 1 will be for score 1 and it will have 50% for 3, 50% for 1.

I am unable to figure out what goes where in x & y axis and series. Any help would be much apreciated!