Filter Epic by Label

Hello,
I would like to make calculated member of Epic Link dimension which would return set of Epics which some label (“MyLabel”). My current (non functional) code is

Aggregate(
  Filter(
    [Epic Link].Members,
    [Epic Link].[Label].[MyLabel]
  )
)

I am obviously mixing two dimensions together, but I am not sure how should I make it. Maybe some tuple?
Thanks in advance!

Hi Petr,

You are correct, this requires reading values from more than one dimension. Following is an example of filtering Epic Link dimension members by a generated list of Labels for Issue with the same key as Epic Link. This is necessary to find the Epic issue itself, not the issues with Label within the Epic.

Aggregate(
  Filter(
    [Epic Link].[Epic].Members,
    Generate(
      Filter(
        [Label].[Label].Members,
        ([Measures].[Issues created], 
          [Issue].[Issue].getMemberByKey([Epic Link].CurrentMember.key),
          [Epic Link].DefaultMember) > 0 AND
        [Label].[Label].CurrentMember.Name <> '(none)'), 
      [Label].[Label].CurrentMember.Name, ', '
    ) MATCHES "MyLabel"
  )
)

Lauma / support@eazybi.com

We have fund issue, that this formula was expecting only 1 label in the issue. Lauma was able to provide solution by following code.

Aggregate(
  Filter(
    [Epic Link].[Epic].Members,
    Generate(
      Filter(
        [Label].[Label].Members,
        ([Measures].[Issues created], 
          [Issue].[Issue].getMemberByKey([Epic Link].CurrentMember.key),
          [Epic Link].DefaultMember) > 0 AND
        [Label].[Label].CurrentMember.Name <> '(none)'), 
      [Label].[Label].CurrentMember.Name, ', '
    ) MATCHES "(^|.*, )MyLabel($|,.*)"
  )
)

Thank you Lauma!

1 Like

Here is an update to this question: starting eazyBI version 4.5.4 filtering child issues by Parent values has become easier - you can define Issue link field dimensions in eazyBI advanced settings and select them for import.

For example, to create Epic Label dimension you would add following advanced settings

[[jira.issue_link_field_dimensions]]
name = "Epic Label"
source_dimension = "Label"
issue_id_column = "epic_id"
group = "Linked issue dimensions"

After changes in advanced settings open source data Jira import options for edit and select Epic Label dimension in tab Additional options section Issue link field dimensions and run the import.

Lauma / support@eazybi.com

2 Likes

Awesome new feature, congratulations!

1 Like