The report provides the correct Jira tickets, but is displayed as “mmm dd yyyy” in the chart. If I change to decimal formatting, I get the total value (which is wrong), I would need the row count which is correct).
Thanks for help!
Alex
The overall structure for the calculations is correct. To make this formula work within a report context (what is selected on report rows, columns, and pages), you might want to add a predefined measure to the expression. A measure binds data together and allows you to represent data from different points of view (Dimensions). Therefore, each calculated measure should contain at least one already existing measure or fixed value. Measure is a treasure! (Calculated measures and members - eazyBI for Jira)
In your case, you might want to add measure “Issues with due date” like this:
NonZero(Count(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
isEmpty([Measures].[Issue resolution date])
AND
DateDiffDays(Now(),
[Issue].CurrentMember.get('Due date')) > 0
AND [Measures].[Issues with due date] > 0
)
)
)