Open Issues measure

Hi,

I noticed that Open issues returned the issues that have any resolution different than Resolved as Cancelled but this is not accurate. How to fix this ?

Thanks

Hi @Sally_Makhlouf

The predefined measure “Open issues” returns issues that do not have a resolution date in Jira.
Please check if your current workflow sets resolution date for other resolutions and Canceled status,
If not, this is the reason why they appear as “open issues”.

Another solution besides changing workflow you might consider is defining all your resolved/closed statuses as “closed statuses” in eazyBI import options.
https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/issues-closed-measure

And then create a new user-defined calculated measure “not closed issues” that would look at closed statuses (to count not closed issues) and won’t care about resolution dates.

Try this formula once you imported all your closed statuses as “closed”

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

It would count all issues that are not in closed statuses.
But the second approach won’t work with resolutions, just with closed statuses.

Martins / eazyBI support

1 Like

Thank you so much for your response!

Hi @martins.vanags,

I checked some tickets… they have a resolution date but still showing in Open Issues. Any reason why this is happening?

Thanks
Sally

There could be few reasons why this happens.

  1. your report is filtered by time, then eazyBI checks when exactly is that resolution date and for all time periods before the filtered one issue would still appear as “open”
  2. Resolution date exists in Jira, but is not imported in eazyBI yet. Please check “Issue” dimension members at issue levels with the property “Issue resolution date” in columns to find out if these tickets really have resolution date in eazyBI.

Martins / eazyBI team