Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Additional Average Functions: PRODUCT, GEOMEAN
Migrateduser
Currently, BIRT has large number of aggregation functions, but non of them can handle calculations involving compounding - (geometric averages).
Does anyone know how much effort it will be to add the following Excel-like aggregations:
PRODUCT(x) - Multiplication of all the values X(1)*X(2)*X(3) of a series.
GEOMEAN(x) - Geometric mean, simply calculation as GEOMEAN(X) = PRODUCT(X)^(1/COUNT(X))
Implementing those calculation as a built-in function will simplify reporting for time-series data. In many cases, historical data is collected on a daily basis, but need to be reported on monthly, weekly, etc. With the new functions it will be simply monthly_total = PRODUCT(1+daily)-1 - which will include the compounding effect, whereas the AVERAGE(daily) does not include compounding effect.
Using the excel-like names and behavior will make it them much easier to locate and use.
Find more posts tagged with
Comments
There are no comments yet