[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
|
- From: lars.johansson@xxxxxxxx (Lars Johansson)
- Date: Fri, 4 Jul 2008 07:58:16 +0000 (UTC)
- Newsgroups: eclipse.birt
- Organization: Eclipse
- User-agent: NewsPortal/0.36 (http://florian-amrhein.de/newsportal)
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