Data Transfer Jira to EazyBI

Questions & Answers
1

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

2

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