Average Age with Issue Target Start Date

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. Not all of the story cards have used the Issue Plannes Start field, but I would like to calculate this for those that do.

Can anyone help??

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

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

Hi Janis,

Thank you for the quick reply! I’ve tried two different iterations using the “Average age of Open Issues” and swapping out “Created at” for “Target Start” (my customers decided on the Target Start field instead of Planned Start) but I’m not getting any results. Can you please take a look and make sure I’m formatting the custom field correctly? Are either of those in the right direction?

Thank you!

#1

CASE WHEN [Measures].[Open issues] > 0 THEN
Avg(
Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateBeforePeriodEnd(
[Issue].CurrentMember.get(‘Target Start Date’),
[Time].CurrentHierarchyMember) AND
NOT DateBeforePeriodEnd(
[Issue].CurrentMember.get(‘Closed at’),
[Time].CurrentHierarchyMember)
),
CASE WHEN
([Measures].[Issues created],
[Time].CurrentHierarchy.DefaultMember) > 0
THEN
CASE WHEN DateInPeriod(Now(), [Time].CurrentHierarchyMember)
THEN DateDiffDays([Issue].CurrentMember.get(‘Target Start Date’),
Now())
ELSE DateDiffDays([Issue].CurrentMember.get(‘Target Start Date’),
[Time].CurrentHierarchyMember.NextStartDate)
END
END
)
END

#2

CASE WHEN [Measures].[Open issues] > 0 THEN
Avg(
Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateBeforePeriodEnd(
[Issue].[Measures].[Issue Target start],
[Time].CurrentHierarchyMember) AND
NOT DateBeforePeriodEnd(
[Issue].CurrentMember.get(‘Closed at’),
[Time].CurrentHierarchyMember)
),
CASE WHEN
([Measures].[Issues created],
[Time].CurrentHierarchy.DefaultMember) > 0
THEN
CASE WHEN DateInPeriod(Now(), [Time].CurrentHierarchyMember)
THEN DateDiffDays([Issue].[Measures].[Issue Target start],
Now())
ELSE DateDiffDays([Issue].[Measures].[Issue Target start],
[Time].CurrentHierarchyMember.NextStartDate)
END
END
)
END