Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Interpolating values: how?
Interpolating values: how? [message #512744] Sun, 07 February 2010 03:17 Go to next message
Nicola is currently offline NicolaFriend
Messages: 184
Registered: July 2009
Senior Member
Hi,
I need to display some data interpolating missing values. Here an example:

Monday...150
Tuesday...missing
Wednesday...missing
Thuesday....400
Friday...missing
Saturday...missing
Sunday...800


When I retrieve and display values I need to create "missing" values and
calculate a value (with a function I have).
But how could I do that? Computed columns?
Birt is very flexible and probably allows me different ways.
Could you please suggest me the best practice?
Any example?

Thank you very much and best regards,
Nicola
Re: Interpolating values: how? [message #512816 is a reply to message #512744] Mon, 08 February 2010 01:26 Go to previous message
Richard A. Polunsky is currently offline Richard A. PolunskyFriend
Messages: 212
Registered: July 2009
Location: Houston TX
Senior Member

If you have the full week coming out in the same row of data, interpolation is straightforward and you might be able to do it in your query.

If each day is a separate row, you actually need two processing runs, one to retrieve the data and store it somewhere, and another to identify the places where interpolation is needed and compute it. I don't see any simple way of accomplishing that.
Previous Topic:Leaving "blanks" in line graph for missing data
Next Topic:[Tribix 2.5.1] xls is lock, can't release.
Goto Forum:
  


Current Time: Fri Mar 29 14:02:57 GMT 2024

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

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

Back to the top