area chart y-series grouping

Hi -
I have a stacked area chart where I am doing a running sum over time (x-axis) of some numeric data.
Without y-series grouping, I get what I expect (top figure of attached image).
However, when I want to group on a text series, I get something that isn't stacked anymore and the running sum seems to be off (bottom figure of attached image).
Can anyone help me?
When I add my y-series grouping I'm expecting to see the same plot as the above graph, but with part of it (which represents the grouping) in a different color...

Find more posts tagged with

Comments

robertl

This is something like I'm expecting to see...the same plot shape for my running sum, but the series grouping simply displays what portion of my running sum falls in which y-series group....

If I'm doing something wrong, someone please tell me how to get what I'm looking for...

mwilliams

Hi robertl,

So, one series is the actual data value and the other is the running sum of those data values? Can you include some data how yours looks so I can create a report design with it? Or you could make something with the sample database and attach that design.

robertl

Not exactly.
I have one series containing the actual data values.
I use x-axis (category) grouping to do a running sum of those data values.
This gives me what I want in terms of my area chart.
But now I want to go one step further and see of those data values, which fall into another grouping (in this case, whether the utilized hours use what portion of the entire resource).
I will see what I can do about trying to re-create in the sample database...

robertl

ok - this is about the best I can get using the sample database.
I've created a report that displays a chart attempting to show a running sum of order totals for 12/2004 and customer Euro+ Shopping Channel.
Without the y-grouping, the area chart displays the correct running sum of the amounts ordered in Dec. 2004.
The minute I add a Y-series grouping to try and display of that running sum, what percentage is of what product line, my chart gets all messed up.
Take a look at hopefully you can tell me what I'm doing wrong.

If you are doing a running sum or some other type of category grouping, does that grouping also get applied separately to each y-series grouping? I would think it gets applied to the entire dataset and then the y-series grouping gets applied, but it seems like the y-series grouping gets applied and then for each of those, the category grouping gets applied...

mwilliams

robertl,

From the looks of it, you may need to separate out the different "types" in computed columns and use them as separate series'. It seemed to work much better that way for me.

robertl

mike - can you post the report design file where you made it work?
I'd like to take a look...

mwilliams

robertl,

This is just what I had thrown together real quick from your design. I added some computed columns and two charts that use those values. There still seems to be an issue with the x-axis with this approach, but the charts seem to look correct. I'd have to mess with it more to see if I can figure that out, but maybe this'll help you anyways.

Good luck.

mwilliams

I used BIRT 2.3.1.