How to calculate Open Issue


#1

Hello,

I would like to filter the Open Issues. The problem is that I have always the ticket in status Closed and Resolution Done in the list.
Here are the calculation :

CASE WHEN [Issue].CurrentMember.Level.Name <> ‘Issue’ THEN
Cache(
NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),
Cache([Measures].[Issues created]
- [Measures].[Issues resolved])
))
+ [Measures].[Issues created]
- [Measures].[Issues resolved]
)
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(‘Resolved at’),
[Time].CurrentHierarchyMember),
([Time].CurrentHierarchy.DefaultMember,
[Measures].[Issues created]),
0
))
END

Many thanks in advance for your help.

Regards,
Trang


#2

Hi,
The reason why the Open Issues measure shows with the Closed status is that you use the Time dimension in the report rows. The Open issues measure shows the number of the unresolved issues at the end of the selected period using the current status status of the issue.

As you can see, the number in the Closed status goes down to zero as the Time approaches the current date (currently Closed issues are not Open).

Perhaps, if you wish to see the historical status of the issues, you might need creating a variant of the Cumulative flow diagram showing the number of issues in each status historically:
https://docs.eazybi.com/eazybijira/learn-more/learn-eazybi-through-examples/history-of-issue-statuses
Note that this report uses another dimension “Transition status” working with the Issues history measure.

Kindly,
Janis, eazyBI support