Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

EazyBI - How to filter to see a subset of a dimension with labels

I am trying to create a chart has labels as a dimension and limit the reported dimension with additional label(s). i.e. number of tickets that have both label1 AND label2 over time. 

I've tried to create a calculated member formula without success. I even tried to tweak the formula for this related question ( and couldn't get the result I was looking for. Any thought?

Thank you. 

5 answers

Hi, David

You could try Aggregate function to create a calculated member in Labels dimension either by listing label members:


 or calculating them dynamically if they match some pattern:

    [Label].CurrentMember.Name MATCHES 'Test.*'


Daina /

Hi @Daina Tupule, Thank you for the reply.  For the first suggestion, it will show JIRA tickets that has either Test1 or Test2 labels. This is not what I am trying to accomplish. I am looking for tickets that have Test1 and Test2 labels. The second suggestion works fine for all labels that start with the same prefix. The labels that I plan to use does not share any prefix at all. i.e. Test1, MyRealTestLabel1, SomeOtherName, etc. I tried to nest two filters and it doesn't work for me.


    [Label].CurrentMember.Name MATCHES 'testLabel'),
    [Label].CurrentMember.Name MATCHES ‘second2'

I've also tried to use and, which also does not work. 

[Label].CurrentMember.Name MATCHES 'testLabel' and
[Label].CurrentMember.Name MATCHES 'second2'

The way I verified this is using this JQL: "labels = testLabel and labels = second2" I am able to see search results in JIRA with this query. The part I can't figure out is how to translate this information into a chart within EazyBI. 

Any recommendation?

Hi David

I missed the part you would like to count issues with all listed labels.

You could use this calculated member (let's name it 'TEST labels') created in Labels dimension to create a new calculated measure in Measures dimension to count issues with all labels in this calculated member 'TEST labels'.

You could use this formula:

  Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
  ([Measures].[Issues created],
  [Label].[TEST labels]) = Count(ChildrenSet([Label].[TEST labels])))

This formula will count all issues that have all labels in 'TEST labels'. A tuple  'TEST labels' with measure 'Issues created' is used to retrieve label count from TEST labels for this issue and then it is compared to label count in calculated member 'TEST labels'. 

Hi @Daina Tupule, 

Thanks for the follow-up. I got out of memory error when tried your latest formula. Other charts seems to still load correctly. So, looks like this calculation is taking more memory. 

Failed to execute query. Error message:
OutOfMemory used=1305651120, max=1431830528

If I create a calculated measure in Measures dimension with the following, I can see a count of issues that has "TEST labels". However, when I tried to add Label column next to Measures to filter on a secondary label, say "A Second Test", I don't see issues being filtered in the chart. (i.e. number of issues didn't decrease)


([Measures].[Issues created],
  [Label].[TEST labels])

Hello David, I was just wondering whether you were able to resolve the problem that you were having?

I am currently trying to group issues which have Label 1 AND Label 2, but have had no luck so far...

Many thanks 

HI @David Lin

might be you are looking for result like as below Image.




Hi @Yogesh Mude[Jira], I am actually looking for a way to have one of the lines to represent count for multiple labels. For example, the last label is "Test" in the image you shared. In the scenario that I want to create, this "Test" line represents number of JIRA tickets that has two or more labels, for example "Test1" and "Test2". To do this, I figured that I need to create a calculated member formula and I couldn't figure out how to do so. 



Im having having the same issue.. need to count the number of tickets with that label.

Anyone solved it?

Yes Juliana, i have added a comment below with calculated member details. :)

Hello All.

After much trying , i found a solution that worked for me.  

--iterate through issues

([Measures].[Issues created],
([Measures].[Issues created],
[Label].[MyLabel2]) > 0



Let me know if this worked for you!


Hi All - 
I'm still searching, but I'm looking for a solution that is [Label1] and [Subset list of multiple labels] - it's two carveouts, everything in the subset that has Label1... Do I have to do that individually?

Trying to avoid

Does anyone have any thoughts or pointers?



The solution demonstrated by @Mitesh Verma is on the right track.

It can be advanced further with the following.


1) Create aggregated members for both subsets of labels.

2) Filter and count the set of issues matching the condition as provided earlier in this thread:


Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
([Measures].[Issues created],
([Measures].[Issues created],
[Label].[subsetlabel1]) = Count(ChildrenSet([Label].[subsetlabel1]))
([Measures].[Issues created],
([Measures].[Issues created],
[Label].[subsetlabel2]) = Count(ChildrenSet([Label].[subsetlabel1]))


Janis, eazyBI support

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you