During Data Transfer I have mapped my resolved, Done and Close under Status Close but EazyBI standard Measure Open also includes resolved. How to fix this issue
Hi @Subodh
Thats great you are using Closed issues functionality in eazyBI.
Now, do I understand correctly, that as of Open issues you want to see all issues that are not closed, i.e. issues that were not moved to any of closed statuses until the end of the selected period?
Then create a custom measure with the following calculation formula:
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]
)
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,
Ilze, support@eazybi.com