Fetch date difference only from epic issue type

Questions & Answers
1

Hi Team ,
I am trying to fetch date difference from 1 to 15 days(Based on Planned end date & Actual end date) only for all the epics. But it is also considering all the issue types.

NonZero(Count(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
DateDiffWorkdays(
[Issue].CurrentHierarchyMember.get(‘Planned End Date’),
[Issue].CurrentHierarchyMember.get(‘Actual Enddate’)
) >= 1
AND
DateDiffWorkdays(
[Issue].CurrentHierarchyMember.get(‘Planned End Date’),
[Issue].CurrentHierarchyMember.get(‘Actual Enddate’)
) <= 15
)
))

this output is including all the issuetypes.

  1. we have used this following formula but it is not working as expected. it is not giving any output eventhough we have data.

NonZero(Count(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
[Issue].CurrentHierarchyMember.get(‘Issue Type’) = ‘Epic’
AND
DateDiffWorkdays(
[Issue].CurrentHierarchyMember.get(‘Planned End Date’),
[Issue].CurrentHierarchyMember.get(‘Actual Enddate’)
) >= 1
AND
DateDiffWorkdays(
[Issue].CurrentHierarchyMember.get(‘Planned End Date’),
[Issue].CurrentHierarchyMember.get(‘Actual Enddate’)
) <= 15
)
))

Please help us with formula to consider only epic’s

2

Hey @lakshay_jeet

First, ensure that both fields “Actual Enddate” and “Planned End Date” are imported as “measures” from the import potions page and then try this formula for your calculated measure:

Note, it requires “integer” formatting.

Sum(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
DateDiffWorkdays(
[Issue].CurrentHierarchyMember.get('Planned End Date'),
[Issue].CurrentHierarchyMember.get('Actual Enddate')
) >= 1
AND
DateDiffWorkdays(
[Issue].CurrentHierarchyMember.get('Planned End Date'),
[Issue].CurrentHierarchyMember.get('Actual Enddate')
) <= 15
AND
[Measures].[Issue type] = "Epic"
),
(
[Issue type].[Epic],
[Measures].[Issues with Actual Enddate]
)*1
)

Martins / eazyBI