Aggregate(
Except(
-- addresses members of a particular level only
[Label].[Label].Members,
{[Label].[tf-ios],
[Label].[tf-android]}
)
)
Hello @Saimond,
Thanks for posting your question.
To get the combination of all label selections, I recommend defining and importing the Label field as a CSV (comma-separated-values) dimension, with parameters in the eazyBI advanced settings similar to the ones below:
[jira.customfield_labelscsv]
name = "Alternative labels"
data_type = "string"
dimension = true
multiple_values = true
split_by = ","
csv_dimension = true
javascript_code='''
return issue.fields.labels.join(",");
'''
You can read more about Advanced settings for custom fields in our documentation here: Advanced settings for custom fields
Make sure you select your newly created custom field and Import it as a dimension:
Once the import is done, you will be able to select Alternative labels CSV Dimension for your report:
You can then add Alternative labels CSV dimension to Rows and also Pages (to filter by any label combination you prefer).
In my report below, you can see that I have Issues with different labels. I can see results with Issues having just the label “app_1” and “app_2” or I can choose to see the Issues that have both labels or any other label combination.
If you wish to exclude certain label combinations, you can simply remove them from the report view or create a new calculated member that excludes these labels.
Best,