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