Count (not archived) fixVersions matching a string

[voi]

Hello,

I’d like to count the (not archived) fixVersions per Jira project matching a certain string (eg. “.*SR.*”).
It should not matter if the fixVersion do have tickets associated or not.

Count(
  Descendants([Fix Version.By status].CurrentMember,
  [Fix Version.By status].[Version])
)

was a good start but I don’t know how to

• sum up unreleased/released versions
• match for a specific string in version name

thanx for any help

[roberts.cacus]

Hi @voi,

I recommend using the Fix Version dimension “Project” level in report rows. That way, the number of versions will be grouped by project. You are off to a good start. To filter the versions by particular conditions, introduce the Filter() function around the descendants. Then add conditions for the version name and stats. The formula could look similar to the one below:

NonZero(Count(
  Filter(
    Descendants([Fix Version].CurrentMember,[Fix Version].[Version]),
    IIf(
      [Fix Version].CurrentMember.Name MATCHES '.*SR.*',
      [Fix Version].CurrentMember.Get('Status') MATCHES 'Unreleased|Released',
      NULL
    )
  )
))

The calculation will first find versions with the particular string and then check their status. The report could look similar to the one below:

Please look at the eazyBI documentation page for more details on functions used in the calculated measure - MDX function reference.

Best,
Roberts // support@eazybi.com

[voi]

Works like a charm. Thank you very much!

How would you sugest to present this at a yearly basis? (release date maybe?)

regards

[roberts.cacus]

Hi @voi,

To group the versions by their release date on the Time dimension, use it in the report rows instead of the Fix Version dimension and alter the calculated measure:

NonZero(Count(
  Filter(
    Descendants([Fix Version].CurrentMember,[Fix Version].[Version]),
    IIf(
      DateInPeriod(
        [Fix Version].CurrentMember.Get('Release date'),
        [Time].CurrentHierarchyMember
      ),
      [Fix Version].CurrentMember.Name MATCHES '.*1.0.*' AND
      [Fix Version].CurrentMember.Get('Status') MATCHES 'Unreleased|Released',
      NULL
    )
  )
))

Best,