Imported Custom Field & Time Calculations

Hi John,

I will jump in your conversation with another suggestion - in the case you have now described you can use the DateDiffDays(…) function and sum the days from RWS date to RWE date. In the example below the issues would be grouped on Time by the RWS date:

Sum( -- Filter issues that have RWS date in the period
  Filter(Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    DateInPeriod([Issue].CurrentHierarchyMember.get('RWS'), 
      [Time].CurrentHierarchyMember) AND -- and when RWE date is not empty
    NOT IsEmpty([Issue].CurrentHierarchyMember.get('RWE')) AND -- and are created in the current report context
    ([Measures].[Issues with RWS], 
     [Time].CurrentHierarchy.DefaultMember) > 0 
  ), 
      DateDiffDays(
        [Issue].CurrentMember.get('RWS'),
        [Issue].CurrentHierarchyMember.get('RWE'))
)

Please make sure that the naming of all measures and properties match your Jira/eazyBI setup.
Lauma / support@eazybi.com