Date Diffence between Parent start date and child resolution date

Questions & Answers
,
1

Hi everyone,

I’m trying to get a measure that will tell me the amount of days between the Parent’s Start date and the child (sub-task) resolution date.

Is there a way to do this?

Appreciate the help thank you!

2

Hi Esteban
Thank you for reaching out to the eazyBI community!

The following formula would calculate the days between the two dates (taking into account the time of events):

DateDiffDays(
[Issue].[Issue].GetMemberByKey([Issue].CurrentHierarchyMember.Get('Parent issue key')).Get('Created at'),
[Issue].CurrentHierarchyMember.Get('Resolved at'))

If you are interested in workdays, use the DateDiffWorkdays function instead of DateDiffDays.

Let me know if there is anything else I can help you with.

Best,
Ilze

1 Like