Filter open issue by summary

Questions & Answers
, , ,
1

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

2

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 - Global calculated fields.

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;
}
return 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:

Screenshot 2021-02-15 at 18.23.55
Screenshot 2021-02-15 at 18.23.551234Ă—1268 91.8 KB

Best,
Roberts // support@eazybi.com

3

You can makean account-specific calcuted field to group issues by “Issue summary Developer”. Please see the documentation for more details: Account specific calculated fields

The settings should look like the one in the picture below.

Account specific calcaulted field
Account specific calcaulted field1454Ă—1692 216 KB

The JavaScript code is the same as mentioned: Filter open issue by summary - #2 by roberts.cacus

var result;
if (issue.fields.summary && issue.fields.summary.match(/.*developer.*/)) {
  result = true;
} else {
  result = false;
}
return result;

Best,
Zane / support@eazyBI.com

4

I created a custom property similar to the above. (I also swapped true and false logic)

If I use it with “Issue” dimension on rows, I can see “True” or (none) values.
But how can I use it in a calculated measure filter to say, for example:

I want Open tickets where my new custom property is true.

5

@guillolb, you should import this new field as a dimension. Then, you can use the new dimension on the report page filter to filter data by (none) or true values.

Best,
Zane / support@eazyBI.com

1 Like