Filter open issue by summary

[karim]

Hi team

i created a new calculated member in the issue dimension to filter issues which contain WHD in summary .
This is my calculated member

 Aggregate(
    Filter(
        [Issue].[Issue].Members,
        [Issue].CurrentHierarchyMember.Name matches "(?i).*WHD.*"
    )
)

The problem is really the report is very very slow
I dont like to create a custom field can you please provides me other solution to make my report not slow.

I teyed to defined a new user defined measure , i just copy the code from open issue measure and i just edit the first line to filter issue by summary but it didnt works .

This is my user defined measure

CASE WHEN
  [Issue].CurrentHierarchyMember.Name MATCHES "(?i).*WHD.*" THEN

  Cache(
    NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),
      Cache([Measures].[Issues created]
          - [Measures].[Issues resolved])
    ))
    + [Measures].[Issues created]
    - [Measures].[Issues resolved]
  )
  
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

Thankyou in advance

Regards
Karim

[roberts.cacus]

Hi @karim ,

I don’t recommend defining such calculated members in the Issue dimension. They are a performance risk.

If you don’t have the option to create a new custom field in Jira, define a new JavaScript calculated custom field in eazyBI. See more details on how to do that here - JavaScript calculated custom fields - eazyBI for Jira.

Add parameters similar to the one below to your eazyBI advanced settings:

[jira.customfield_developer_issue]
name = "Issue summary Developer"
data_type = "string"
dimension = true
javascript_code = '''
var result;
if (issue.fields.summary && issue.fields.summary.match(/.*developer.*/)) {
  result = true;
} else {
  result = false;
}
issue.fields.customfield_developer_issue = result;
'''

This particular JavaScript custom field will return the value “true”, if the issue summary has the word “developer”. Alter the parameters to fit your use-case.

You can then update the eazyBI advanced settings and select the newly defined custom field for import as a dimension in the import options. Finally, you can use the dimension in the pages of the report to filter the report results. See an example below:

Best,
Roberts // support@eazybi.com