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?