JIRA EazyBI: filter row with Sprints matching Sprint names starting with "XYZ"

[Randy_Elias]

Hi All,

  EazyBI Newbie here. I want to create a Line Report where the number of Hours Spent on JIRA issues from a specific fixVersion is plotted against each Sprint.

  I am able to correctly filter the number of Hours Spent. However, I am having problems filtering on the specific Sprints I want to plot the data against. 

  Can someone please help me with the calculated member formula to filter on Sprint Names starting with "XYZ"?

  Perhaps there's another way to go about this?

Thanks,

   Randy

[Roberts Čāčus - eazyBI]

Hi Randy,

This is Robert from eazyBI support here.

To create a calculated member in the Fix version dimension, that groups together several versions which names start with similar symbols, please try the formula below:

Aggregate(
  Filter(
    [Fix Version].[Version].Members,
    [Fix Version].CurrentHierarchyMember.Name MATCHES '^XYZ.*'
  )
)

 You can read more on the regular expressions used here on our documentation page.

Kind regards,

Robert eazyBI support