Building Report for Issues with Two Labels

Questions & Answers
, , ,
1

I have a Jira filter that I use constantly that filters issues to only ones that have both Label1 and Label2.
The JQL looks like this “labels = label1 AND labels = label2”.

I am trying to build a report in easyBI that will filter the same way. I have only been able to get it to do the “OR” functionality.

How would this be accomplished?

2

Pages selection works like IN / OR within one dimension member selection.

You would like to use some other approach to filters issues with two labels. The filter should be on issue level. You can use issue property Issue labels (available on cloud or with the version 6.1 on server/DC)

  1. The simple way is adding this issue property Issue labels to the report with the issues on Rows. Then click on the header for Issue labels and apply rows filter with one value and then repeat the same steps with another value. Then the report will filter a list of issues based on values in both filters.

image
image1692×596 73.7 KB

  1. If you would like some more advanced formula to count totals based on the selection of labels, you can consider this one. I am counting story points for all issues that have all of the labels selected on the pages.
 CASE WHEN [Label].CurrentMember is [Label].DefaultMember
    THEN
    NonZero([Measures].[Story Points created])
    ELSE
    Sum(
      Filter(
        Descendants([Issue].CurrentMember,[Issue].[Issue]),
        -- count of labels with a match in isuse is the same as selecged on pages 
        count(intersect(
        ChildrenSet([Label].CurrentMember),
          [Label].[Label].GetMembersByKeys([Measures].[Issue labels])
        )) = 
      count(ChildrenSet([Label].CurrentMember))
      ),
      ([Measures].[Story Points created],
      [Label].DefaultMember)
    )
    END

Then you can use any dimension on the report and see totaling values, for example, by status:

image
image1426×778 53.2 KB

Daina / support@eazybi.com

3

Hello! I’m unable to work out how “Then click on the header for Issue labels and apply rows filter with one value and then repeat the same steps with another value” works after adding “Issue Labels” on Rows.

A bit more detail on that, please?

Only Pages filters appear on the chart header; Rows filters do not appear on the header at all.
Once I apply one Pages filter, I don’t seem to be able to apply a second one. Only the last one selected sticks

4

Sorry for the late reply!

You can use described solution with filter rows by issue labels only if you are using Issues in the report on Rows. Add property Issue labels. In the table report click on the header of the rows for this column with property Issue labels. Select the option matches - as many times as how many labels you would like to use the issue should match all. See this screenshot with more details.

image
image1816×980 173 KB

Daina / support@eazybi.com