Discrepancies with Open Issues calculations (JIRA)

Questions & Answers
4

@Daniel_Luevano,

Measure Open issues is a calculated measure based on issue creation and resolution dates. You may create a similar calculated measure that is based on issue creation and closing dates by using closing date, and “Issues closed” measure instead.

  1. Make sure you have imported Closing date and measures: https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/issues-closed-measure

  2. Copy the formula of “Open issues” to use it as a template for now calculated measure.

  3. Define a new calculated measure “Open issues by close date” and paste in the formula of “Open issues”.

  4. Modify formula. Replace “Issues resolved” with “Issues closed”, and replace property “Resolved at” with property “Closed at”, and replace predefined measure “Issues due” with the difference between created and closed issues. The updated formula might look like this:

    CASE WHEN [Issue].CurrentMember.Level.Name <> 'Issue' THEN
  Cache(
    NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),
      Cache([Measures].[Issues created]
          - [Measures].[Issues closed])
    ))
    + [Measures].[Issues created]
    - [Measures].[Issues closed]
  )
WHEN [Time].CurrentHierarchyMember IS [Time].CurrentHierarchy.DefaultMember
THEN NonZero(
  [Measures].[Issues created]
  - [Measures].[Issues closed]
)
ELSE
  -- optimized formula for drill through Issue
  NonZero(IIF(
      DateBeforePeriodEnd(
        [Issue].CurrentMember.get('Created at'),
        [Time].CurrentHierarchyMember) AND
      NOT DateBeforePeriodEnd(
        [Issue].CurrentMember.get('Closed at'),
        [Time].CurrentHierarchyMember),
    ([Time].CurrentHierarchy.DefaultMember,
      [Measures].[Issues created]),
    0
  ))
END

Best,
Zane / support@eazyBI.com

4 Likes