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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Stacked Bar Chart

Started by beerguy82, 10 Mar 2010 02:45:29 PM

Previous topic - Next topic

beerguy82

Hi All -

I'm having some trouble getting the Stacked Bar Chart type to act as I think it should.  Here is the basic premise of it...

I have a single data item.  I am using a count() function to get the total # of those items.  The item value is actually just a 0 or 1 depending on whether it is 'to standard' or not, so I use a total() function to get the total 'to-standard'.

What I want to do is have the count() item and the total() item stacked on top of each other, the highest point on the axis being the count() and the total being a section of the bar that reaches only part of the way up.  Currently I have only been able to get this to work as a clustered bar chart, but I believe it will be more visually impactful if it is stacked (and it will also have a lot more room on the Y-Axis, which is good because this is going to stretch across a 12 month period by month).

Any help would be greatly appreciated.

Tim