Datacube - Average function in summary field

Hi,

I'm using BIRT 2.3.2 for some compliance reasons and after creating a data cube i noticed that there is no way to make a summary field with the "Average" function.

I've only those functions: SUM / MAX / MIN / FIRST / LAST / COUNT / COUNTDISTINCT

Is there a way to make it and is this problem still in 2.5 ?

Regards - Matthieu

Find more posts tagged with

Comments

mwilliams

Hi Matthieu,<br />
<br />
There is no AVG function in 2.5 either. One way to compute the average yourself would be to add a measure with the function SUM, a measure with the function COUNT, and then add a derived measure that figures the AVG. You can request an enhancement on this issue at <a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/reportabug.php'>BIRT: Reporting Bugs and Requesting Enhancements</a>.<br />
<br />
I'll let you know if I figure out any other workaround.

Virgil Dodson

I created an example of an average column in a crosstab with BIRT 2.3.2 using a derived measure. It is enclosed.

Matthieu

Thank you both for your answers.

Thanks to Virgil, I succeed to calculate the average but now I realised that i'm stuck to calculate the standard derivation.

Thanks again.