Report is taking long time to load if am using custom measure to get the count of issues if custom date field is empty

Report is taking long time to load if am using custom measure to get the count of issues if custom date field is empty

Custom Measure used for the report

NonZero(
Sum(
Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
IsEmpty([Measures].[Issue Fix Date]) AND
([Measures].[Issue type] = “Defect”)
),
– counter by measure works as a filter as well:
([Measures].[Issues due],
[Time].CurrentHierarchy.DefaultMember)
)
)

Thanks,
Padma K

Hi @PADMA_KOTHAKOTA,

Caclautions that iterate through individual issues (Descendants of Issue dimension) are precise but quite resourceful and might impact report performance.

You might look for a different approach to identifying unresolved issues without a fix date.

  • When you import a date field, eazyBI creates a new measure, “Issues with XXX date”, in your case, “Issues with fix date”. You might want to use this measure to identify issues that have a date field and then subtract them from all issue amount to find issues without the fix date.
  • And use the dimension “Resolution” to identify unresolved issues (without resolution).

Using those building blocks, you may rewrite the calculated measure using a tuple expression that works faster.

--all unresolved defects
([Measures].[Issues created],
[Issue Type].[Defect],
[Resolution].[(unresolved)])
-
--substract unresolved defects that have Fix Date
([Measures].[Issues with Fix date],
[Issue Type].[Defect],
[Resolution].[(unresolved)])

Here are more details available measures for custom date fields and tuple expressions:
https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields#Jiracustomfields-Measureswithcustomdatefields
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures#Calculatedmeasures-Tuples

Best,
Zane / support@eazyBI.com

Thanks much Zane for the solution :slight_smile: . Using the provided solution measure now report is not taking much time for loading.

Cheers,
Padma K

1 Like