Hi @Vishwas ,
welcome to eazBI community!
A label is a multi-selection field, and therefor filtering issues without some labels are tricky. As issue may have one valid label and one you would like to exclude.
You might want to explore some similar questions and see which of the solutions could work for you:
Hi @Uris ,
I believe you already have sorted out this use case with eazyBI Support.
A label is a multi-selection field, and therefor filtering issues without some labels are tricky. As issue may have one valid label and one you would like to exclude.
Your idea to create a calculated measure that validates labels of all issues is correct. Unfortunately, this type of calculation is quite heavy and resourceful, but there are some improvements you can make.
In the Label dimension, create a calc…
As well as:
Hi @prasad and @enguyen ,
The idea to use aggregate is correct. But in this case, to get the count of issues with specified labels you should aggregate issues instead of labels and for each issue validate assigned labels. For aggregation, you may use function Count() and iterate through issues using function Descendants()
NonZero(
Count(
Filter(
--iterate through issues
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
--which have label FWQA_TestDev
([Measures].[Is…
Here is also a JavaScript calculated customfield example that will have faster performance:
Hi Alex,
You are right, aggregation while excepting some members doesn’t work that well with multiple-value fields. One way to overcome this issue is to create a new dimension based on the existing Label dimension. Create one with the code below:
[jira.customfield_labels]
name = "My Labels"
data_type = "string"
dimension = true
javascript_code = '''
if (issue.fields.labels) {
issue.fields.customfield_labels = issue.fields.labels.sort().join(', ')
}
'''
The code will create a new dimension tha…