Tickets within due date

Hi,
to see all tickets within due date (but no resolved tickets) I tried this formula:

NonZero(Count(
    Filter(
      Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
     isEmpty([Measures].[Issue resolution date])
     AND 
      DateDiffDays(Now(),
        [Issue].CurrentMember.get('Due date')) > 0
    )
  )
)

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

Hi @aalex,

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
    )
  )
)

Best,
Zane / support@eazyBI.com

Hi Zane,
… great, it’s working! Thanks for your help!
best regards
Alex

1 Like