[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [Newsgroup Home]
[news.eclipse.birt] Running Sum strange or wrong - up and to the right

Hi,

I have discovered trouble when using Running Sum in charts. It doesn't seem to work as it should, particularly when combined with grouping on x-axis. When searching this newsgroup I've found some entries however the situations don't seem to apply to me.

Background:
In my situation I have a chart (bar, line, area) with week number on the x-axis and sum on the y-axis. The data set has a number of columns of which week number is one. Each row in the data set also has a column with value 1.


E.g.
Column weeknbr, Column test
801, 1
802, 1
803, 1
803, 1
803, 1
804, 1
805, 1
805, 1

I can display this with Running Sum in chart like "Up and to the right" if I just have row["weeknbr"] on x-axis and row["test"] on y-axis with Running Sum. The example above would then have 8 entries on x-axis and you would see a straight line going up and to the right.

However I want to have 5 entries on the x-axis, so I enable grouping on x-axis value (tried weeknbr both as numeric and string). The grouping works but Running Sum seems to fail. On the y-axis I only get value 1. What I want is:
801, 1
802, 2
803, 5, 804, 6, 805, 8


Is it possible to achieve this, if so how? with grouping on x-axis?

- http://dev.eclipse.org/newslists/news.eclipse.birt/msg10948.html
- https://bugs.eclipse.org/bugs/show_bug.cgi?id=155090


Best regards Lars