Eazy BI

[Sarath]

Hi All,

I am new Eazy BI plugin. I have asked to create a report average number of Open Changes currently. with below formula. 

FORMULA

(Sum of changes created in each month) / # of months elapsed
Example: Jan = 10 change tickets and Feb = 15 change tickets
10 + 15 = 25/2 months = 12.5

Please Advise to achieve above in EAZY BI.

Thanks for Support.

Regards

Sarath

[Janis Plume _eazyBI_]

Hi,

I would propose to use the Add calculated feature and select the average. The report could look like this:

Kindly,

Janis, eazyBI support