Counting Specific Statuses in Custom Fields with eazyBI

Questions & Answers
1

Hello eazyBI Community,

I am currently working on a JIRA project that is regularly synchronized with an external system and includes several custom fields. One of these custom fields, named “Field1,” is a long string that contains various statuses, such as “Status: 01-New,” “Status: 02-Analysis,” and so on, with numbers ranging from 01 to 10.

I would like to focus on counting only the issues that contain specific statuses in this custom field, particularly those with “03-”, “04-”, and “05-”.

Could anyone guide me on how to set this up in the Time dimension of eazyBI? Any help or examples would be greatly appreciated!

Thank you!
Maikl

2

Hi!
If you know that those Custom Statuses won’t change, you only need to create a custom filter to count those issues that matches the condition.
If you already have a Measure to get the value of that Field1 you can replace the
[Issue].CurrentHierarchyMember.get('Field1') for something like:
[Measures].[Issue Field1] (or the name you provided)
You can name like “Count statuses” and provide the formatting as Numeric → Integer.
Custom formula

NonZero(
  Count(
    Filter(
      Descendants([Issue].CurrentMember, [Issue].[Issue]),
      (
        [Issue].CurrentHierarchyMember.get('Field1') MATCHES ".*03-.*"
        OR
        [Issue].CurrentHierarchyMember.get('Field1') MATCHES ".*04-.*"
        OR
        [Issue].CurrentHierarchyMember.get('Field1') MATCHES ".*05-.*"
      )
    )
  )
)
3

Thank you for your proposal. Unfortunately, the numbers are not calculated in the Time dimension. When I try to extract the “Status” from “Field1” using

ExtractString([Issue].CurrentMember.Get('Field1'),"Status: ([0-9]{2})-",1)

and use this calculated member as a column showing the issues, I get “03”, “05”, etc. It seems to be a problem only in the Time dimension. Also, the calculation itself takes quite long. What could be the reason?

4

Hi @maikl2025,

How do you intend to tie the count of issues to the particular Time dimension periods? Particularly, by what date?

Additionally, if the field contains comma-separated values, you can try to import the field as a multi-value dimension with additional settings, particularly with the multiple_values = true and split_by = "," settings - List of custom field advanced settings.

That way, the field can be imported as a dimension, and you can select the desired values. Then, in the report, you can select the desired measure by which to tie the count of issues to the Time dimension. For example, with “Issues created”, the number of issues will be tied by the issue creation date. See more measure examples here - Jira Core measures and dimensions.

Best,
Roberts // support@eazybi.com

5

I would like to count the number of such issues weekly. Unfortunately, I cannot influence how the issues or custom fields are imported since all of this is managed centrally as part of a larger project organization.