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 that contains a single value for each issue. The value consists of all the issues labels joined together. The calculated measure should work using this dimension.
Kind regards,
Robert / eazyBI support.