Eclipse Community Forums: BIRT

Help

Home

Home » Archived » BIRT » Deccumulation?(Running sum that ends on zero)

Show: Today's Messages :: Show Polls :: Message Navigator

Deccumulation? [message #1637023]

Thu, 26 February 2015 13:53

Theo Brayford

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 : )

Report message to a moderator

Re: Deccumulation? [message #1638595 is a reply to message #1637023]

Fri, 27 February 2015 07:36

Theo Brayford

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

Theo Brayford

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.

Report message to a moderator

Re: Deccumulation? [message #1643817 is a reply to message #1640017]

Sun, 01 March 2015 19:42

Theo Brayford

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

Michael Williams

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

Report message to a moderator

Previous Topic:	Change Hyperlink Parameter Name at Runtime
Next Topic:	How do I get multiple parameter values processed in a Data Set?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 15:57:43 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter