I can't get it to work properly in charts. Each row in a data set have
some columns of which week is one and another one is test, always with one
as value. This I want to show in a chart as number of hits per week; can
be done if I do it as a simple line chart.

If I want to show it as a running sum with value grouped per week, this
doesn't work (running sum always return 1).

Lars Johansson wrote:
> Hi,
>
> anyone worked with RunningSum in BIRT?
>
> I can't get it to work properly in charts. Each row in a data set have
> some columns of which week is one and another one is test, always with
> one as value. This I want to show in a chart as number of hits per week;
> can be done if I do it as a simple line chart.
>
> If I want to show it as a running sum with value grouped per week, this
> doesn't work (running sum always return 1).
>
> Grouping on x-axis seems part of the problem.
>
> Is possible to have Running Sum in charts in BIRT?
>
> Best regards
> Lars
>
>
>

this may be a bug. Can you log it and submit your example report with
it. It appears doing the grouping on the xaxis is taking out the
running sum, which makes sense as the running sum most likely only
functions within the group. As a work around you may be able to do it
in an table, then use the table as a source for the chart and then hide
the table.

this may be a bug. Can you log it and submit your example report with
it. It appears doing the grouping on the xaxis is taking out the
running sum, which makes sense as the running sum most likely only
functions within the group. As a work around you may be able to do it
in an table, then use the table as a source for the chart and then hide
the table.

Can you not group the table and use the aggregate binding in the chart?

Jason

On 1/7/2011 8:26 AM, Loïc Bertholet wrote:
> Hi Jason,
>
> This post is a very old one but can you still tell me more about the
> mentionned workaround please ?
>
> With a group in a table i'm able to give the following data set to the
> chart :
>
> nbr week val week_sum week_run_sum total_run_sum
> 1 1 1 3 1 1
> 2 1 1 3 2 2
> 3 1 1 3 3 3
> 4 2 1 1 1 4
> 5 3 1 2 1 5
> 6 3 1 2 2 6
> 7 5 1 1 1 7
> 8 6 1 1 1 8
> 9 8 1 2 1 9
> 10 8 1 2 2 10
>
> As it is the container dataset, i can't group on x axis or use filter to
> obtain an adequate dataset
>
> Is it possible to use only the table group values as a source for my
> chart ? Or do you suggest something else ?
>
> Thanks,
>
> Loïc
>
> [quote title=Eclipse User wrote on Fri, 25 July 2008 12:37]Originally
> posted by: jasonweathersby.alltel.net
>
> Lars,
>
> this may be a bug. Can you log it and submit your example report with
> it. It appears doing the grouping on the xaxis is taking out the running
> sum, which makes sense as the running sum most likely only functions
> within the group. As a work around you may be able to do it in an table,
> then use the table as a source for the chart and then hide the table.
>
> Jason
>

Originally
> posted by: jasonweathersby.alltel.net
>
> Lars,
>
> this may be a bug. Can you log it and submit your example report with
> it. It appears doing the grouping on the xaxis is taking out the running
> sum, which makes sense as the running sum most likely only functions
> within the group. As a work around you may be able to do it in an table,
> then use the table as a source for the chart and then hide the table.
>
> Jason
>