Multi values fields include and exclude values

Questions & Answers
1
  • How to handle multi value fields in MDX of calculated members
    When handling multi value fields, I would like to find a way to include some values and exclude some other values.
    For example, in ‘Label’ field, I want to count if the values have ‘A’ but have not ‘B’.
    I was using:
    Aggregate(
    Except(
    [Label].[A],
    [Label].[B]
    )
    )
    But the result still includes ‘B’ in label when both ‘A’ and ‘B’ are existing in the values.
    Can anyone help? Thanks!
2

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.