EazyBI - Average Age with Issue Planned Start

[Alex Boser]

Hello! 

I'm looking to replicate the Average Age calculation field in Eazy BI, but I would like to use Issue Planned Start as the starting date instead of Issue Created Date.  Can anyone help? Not all of the story cards have used the Issue Plannes Start field, but I would like to calculate this for those that do. 

(DateDiffDays([Measures].[Issue Planned Start], Now()) / [Measures].[Issues created])

[Janis Plume (eazyBI)]

Hi,

you can check the Average age report in the eazyBI Demo account:
https://eazybi.com/accounts/1000/cubes/Issues/reports/50084-average-age-till-resolution-report

The formula of the "Average age of Open issues" needs an adjustment for your case. Please, replace the "Created at" issue property with the name of your custom field e.g. "Planned Start" and that will be the average age with the Planned Start as the starting date.

Kindly,

Janis, eazyBI support