Labels with Or Statements

[skle]

I am looking to create a report that captures the following per day:
Note some issues might have both labels
issues created with either label A or B
issues resolved with either label A or B
issues created without either label A or B
issues resolved without either label A or B

I have no problem doing this with one label but I need to add in the or statement.

I have defined each label member in the Label dimension

Aggregate(
Filter(
[Label].[Label].Members,
[Label].CurrentMember.Name = “labelA”)
)

Aggregate(
Filter(
[Label].[Label].Members,
[Label].CurrentMember.Name = “labelB”)
)

Then I think I need another calculated member
Aggregate
[Label].[labelA] OR
[Label].[labelB]

Then 4 new calculated members but the counts are off.

I have also added the label combo to the advanced settings.
[jira.customfield_eazybilabels]
name = “Label combinations”
data_type = “string”
dimension = true
javascript_code = ‘’’
issue.fields.customfield_eazybilabels = issue.fields.labels;

Thanks in advance for any help.

[zane.baranovska]

Hi @skle,

There is no need to make calculated measures or import new dimensions to filter issues with label A or label B.

When you have label dimensions on pages and select two labels, those conditions already work with OR condition; eazyBI returns all issues with either label. See the picture below.

You might want to use distinct issues count measures like “Issues created count” if you would like to count issues only once for matching label (more details in the documentation: Jira Core measures and dimensions).

Best,
Zane / support@eazyBI.com