create new formula in eazybi....

[dohyun Lee]

Hi there.

I’m a beginner first of all, and I have small problem with create new formula.

I tried to figure it out with documentation and this Answers page, but I failed it ;(

I want to make a report like this.

<colgroup><col span="2" width="68"> <col width="133"> <col span="4" width="68"> </colgroup>

Version	Released	Released date	total bug	before release	after released	defect detection %
1.0.1 ver	O	2013-12-01 11:04	38	20	18	52.63
1.0.2 ver	O	2013-12-06 15:43	20	18	2	90.00
1.0.3 ver	O	2013-12-10 13:12	32	20	12	62.50
1.0.4 ver	O	2013-12-17 10:12	22	14	8	63.64
1.0.5 ver			9

Problems are ‘before released’ and ‘after released’. I have no idea how to create that formula…

I think if I can refer specific column, for example [issue].currentmember, it can be solved right away.

‘casue I think if I build a new formula in ‘Measures’ dimension which gives value ‘1’ if the bug issue created before version released. Then I can get ‘before released’ column with Sum aggregator..

Has anybody an idea..?

[Raimonds Simanovskis · Accepted solution]

Please see eazyBI sample report with "Issues created before fix version release date" and "Issues created after fix version release date" measures. You can expand Measures / Calculated members and show formulas of these calculated measures and copy them to your own eazyBI installation.

[shinhjc]

I can't access sample report. can I see this report sample?