Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Deccumulation?(Running sum that ends on zero)
Deccumulation? [message #1637023] Thu, 26 February 2015 13:53 Go to next message
Theo Brayford is currently offline Theo BrayfordFriend
Messages: 7
Registered: February 2015
Junior Member
Hi, I'm new to BIRT but am getting on quite well even with my beginner level knowledge of code.

Can anyone help me implement a reversed running sum for a line chart? Essentially the same as a normal running sum but one that ends on zero rather than starting on zero.

The data I'd like to display has two series, both represent the first derivative of a variable. The first series is history data, the second is forecast data. I have a running sum on the forecast data and would like to display the history data inline with it. If the two series could meet at zero that would be perfect.

Any ideas welcome : )
Re: Deccumulation? [message #1638595 is a reply to message #1637023] Fri, 27 February 2015 07:36 Go to previous messageGo to next message
Theo Brayford is currently offline Theo BrayfordFriend
Messages: 7
Registered: February 2015
Junior Member
Or, if no one can think of a way to script this I can perform a union in the SQL query. In which case I have new questions;

Is it possible to set some kind of reference point on the X-axis for where to start the accumulation (naively hoping that history data will just fall into line)
Or more realistically; Can I set markers on the Y-axis at all points where my series crosses the midnight values on the X-axis?

[Updated on: Fri, 27 February 2015 07:37]

Report message to a moderator

Re: Deccumulation? [message #1640017 is a reply to message #1638595] Fri, 27 February 2015 23:15 Go to previous messageGo to next message
Theo Brayford is currently offline Theo BrayfordFriend
Messages: 7
Registered: February 2015
Junior Member
I've been trying a few things out and might be able to narrow down my questions. Combining the series in the SQL query helps with other things so I'm running with that atm.

Can I subtract the entire series by it's value at a specific row number on the chart? Row number 24 for example.

And is there a way to add markers on the x-axis (Datetime) at regular intervals? Such as 00:00 each day?
Under normal data flows this would also have a static row number so I can go with that. It feels like a bit of a workaround, but I've done everything I can to make the data flow into the SQL database as stable as possible so I can live with this much.

Any other ideas such as methods of preprocessing in BIRT welcome.
Re: Deccumulation? [message #1643817 is a reply to message #1640017] Sun, 01 March 2015 19:42 Go to previous messageGo to next message
Theo Brayford is currently offline Theo BrayfordFriend
Messages: 7
Registered: February 2015
Junior Member
Could really do with some pointers.

If I put my data into a table, will I be able to access the value in a specific column and row number for use in a chart expression?

[Updated on: Sun, 01 March 2015 19:43]

Report message to a moderator

Re: Deccumulation? [message #1652481 is a reply to message #1643817] Thu, 05 March 2015 22:28 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

Sorry for the delay. So, you want to take say, a month's data and start at the full value of the month and have each bar step down til the last day of the month based on the sales or whatever for each given day? Am I understanding correctly?

Michael

Developer Evangelist, Silanis
Previous Topic:Change Hyperlink Parameter Name at Runtime
Next Topic:How do I get multiple parameter values processed in a Data Set?
Goto Forum:
  


Current Time: Mon Sep 24 13:43:35 GMT 2018

Powered by FUDForum. Page generated in 0.02853 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top