Filter open issue by summary

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

        [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

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

      Cache([Measures].[Issues created]
          - [Measures].[Issues resolved])
    + [Measures].[Issues created]
    - [Measures].[Issues resolved]
  -- optimized formula for drill through Issue
        [Issue].CurrentMember.get('Created at'),
        [Time].CurrentHierarchyMember) AND
      NOT DateBeforePeriodEnd(
        [Issue].CurrentMember.get('Resolved at'),
      [Measures].[Issues created]),


Thankyou in advance


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:

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:

Roberts //