Create overdue task metrics using Closed Date and Due Date

Questions & Answers
1

Hi,

I need to create a new measure to Overdue tasks, using the date of Closed Date or Transition to status ‘Resolvido’ and compare to Due Date.
I am using the code below, but did not work.

NonZero(
Count
(Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
(DateDiffWorkdays([Issue].CurrentHierarchyMember.get(‘Closed at’),[Issue].CurrentHierarchyMember.get(‘Due date’)) > 0
)
)
)
)

Can anybody help me?
Thanks

2

Try copying the formula from our demo report
https://eazybi.com/accounts/1000/cubes/Issues/reports/249876-issues-due-and-overdue

Check the measure “Overdue issues in period”

In your case, you can define Resolvido as closed status and then use “Closed at” property instead of “Resolved at” in the formula.

Martins / eazyBI

1 Like