Create calculated measures based on some filtering criteria - labels, projects, etc

sboket · February 10, 2025, 10:52am

Hello everybody!

I’ve tried to look for an already answered question but couldn’t find it.

Context:

I have JIRA issues imported in eazyBI, and each issue has a list of Labels (or non)

I’ve just started to use eazyBI, so apologies if my questions are trivial. I would like to achieve the followings:

filter by time (last year, etc) - as common in dashboard - I should be fine with this.
Filter issues by certain labels - ideally regex (e.g Release-*) - applicable for the selected time interval and also remove some issues which don;t have some labels. Probably this needs to be done with a new calculated measure - but I couldn’t figure how to filter by issue. ( just a random example: filter issues with “Release-1”, “Release-3”, “Release-4” , but don’t have the labels “Blocker-Release-1”)
On XAxis show the same filtered labels
create a new calculated measure only with the issues which are part of “Project1” and “Project1”

Thanks a lot!

By the way, I’ve mention I"m new to easyBI, but what I managed to do in 2 days is outstanding. Great product!!

martins.vanags · February 12, 2025, 11:51am

Hi @sboket

Label is a multi-value field in Jira and eazyBI imports it by deafult as multi-value field which would make almost impossible to filter using “except” filters.
it would require complex calculations

Please find this community post: Jira JQL in EazyBI Custom Measure as a Filter - #2 by Elita.Kalane

You could try using CSV feature for new label dimension to import second label dimension “alternative labels” with additional “Alternative Label CSV” dimension where you could create calculated member which groups all possible label combinations that you want to filter in your report.
Try this code for the calculated member in “Alternative Label CSV” dimension:

Aggregate(
  Filter(
    [Alternative Label CSV].[Alternative Label CSV].Members,
    [Alternative Label CSV].CurrentMember.name matches ".*Release-.*"
    AND
    Not [Alternative Label CSV].CurrentMember.name matches "Blocker-Release-.*"
  )
)

Then filter report by new dimension as page filter and show “Label” dimension in rows at label level to show count of issues for each label if they meet the csv criteria (has any of Release-x but don’t have “Blocker-Release” label).

Martins / eazyBI