|Best practices to compute a rate from absolute data [message #651582]
||Mon, 31 January 2011 12:50
| Mike Wulkan
Registered: July 2009
I'm looking for some best practices advice.
I have a database that has many columns containing absolute counts. The database also has an interval column that indicates how many seconds elapsed for that rows count delta.
I would like to plot these columns as rates (ie., r2-r1/interval2).
To do this I have added a computed column to the dataset as follows:
if (lastSentInsertSuccess == -1) lastSentInsertSuccess = row["NumInsertsSentSuccess"];
var tempInsert = lastSentInsertSuccess;
lastSentInsertSuccess = row["NumInsertsSentSuccess"];
This works but it is cumbersome as I need to do this for almost every column in the database. This also requires that I initialize the independent lastxxx variables for each column.
1) Is there a function already hidden in BIRT somewhere that will calculate the difference between adjacent rows?
2) Should I be doing this at the dataset level or should I be doing this in the chart?
Powered by FUDForum
. Page generated in 0.02055 seconds