Filter JIRAs with two labels

Questions & Answers
1

Hello

I’m completely new to EazyBI, so please bear with me.

Within EazyBI, I need a way to filter JIRAs for charting when they have

  • two labels (both labels)
  • more than two labels (all labels applied)

I am on v6.1

Here’s what I have tried:
#1

  • Create a calculated member under Pages/Labels as mLBL1=[Label].[LBL1]
  • Create a calculated measure as mLBL2 = [Label].[LBL2]
  • With mLBL1 selected under Pages/Labels, when I select mLBL2 under measures, I expect only the filtered JIRAs with LBL1 to be listed in the table. However this isn’t the case - all JIRAs with and without LBL1 (but with LBL2) are listed in the table.

#2

  • Drop Labels into the table/chart area and select only LBL1
  • Under measures, select mLBL2
  • Same issue as #1. I still see just LBL2 (not LBL2 filtered with LBL1)
    Within the Chart/Table when I drop the Labels

#3

  • Calculated Measure mLBL1 as [Label].[LBL1]
  • Calculated Measure mLBL2 as [Measures].[mLBL1], [Label].[LBL2]
  • Unfortunately, in this case, mLBL2 counts are identical to mLBL1

#4

  • Any number of count/filter type constructs that have been shown on these forums
  • Almost all of these result in “Out of memory” (with the occasional construct showing up empty)

The final report needs to be in multiple columns within the EazyBI table view like so:

Timeline (Monthly) | LBL1 | (LBL1 + LBL2) | (LBL1+ LBL3 ) | (LBL1 + LBL4) | (LBL1 + LBL5)

I’m unclear about the right approach here, and have had to come here after much reading on these forums and trying various things. Any help appreciated.

So, ideally it would be best if the filter for LBL1 is applied from Pages, and LBL2-LBL5 applied from columns, I suppose? In that case, I need a way where Calculated Measures ([Label].[LBL2] in my case) is prefiltered with the applied LBL1 from Pages?

2

Labels is multiple value field in Jira. There could be many combinations of labels for any issue. eazyBI calculated members in this case will work as if any of the labels as selected.

If you would like to count issues with all labels you can consider two options - use Javascript or MDX calculations for complex cases.

JavaScript might need more setup and maintenance, but it would work faster.
There are several options on how to build those dimensions based on labels:

When importing alternate labels, you can use the additional parameter csv_dimension = true to the definition to import additional dimensions with all the label combinations. CSV dimension will work similarly to single value selection. You can select any combination and eazyBI will give you a unique count of issues with the needed combinations of labels.

This community topic offers a solution to define a new dimension based on explicit label combinations:

You can also use MDX calculation to get the count of issues with a specified label combination. For example, this community topic includes formula counting issues with all the selected level combinations in the report:

Daina / support@eazybi.com

1 Like