Measure that only counts issues overdue with past dates (excluding todays date

Questions & Answers
1

Hi,

I have a measure for returning the number of overdue issues per issuetype, which is great. However it returns issues that have a due date of today and I only want to return issues with due dates in the past.

Can anyone help me update the below? I assume its something to do with the ‘Now’ function, but just can’t seem to get something that works.

NonZero(count(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Issues with due date] >0 and
isempty([Measures].[Issues resolved]) and
DateCompare([Measures].[Issue due date],Now())<0
)
))

Thanks

2

Hi @lawlorj

Please check this Demo report: Issues due and overdue - Issues - Jira Demo - eazyBI

I believe you could re-use the calculated measure “Overdue issues in period” with “Time” dimension members.

Martins / eazyBI