How to exclude specific labels?

Questions & Answers
2

Hi, @Elle

Welcome to the eazyBI community.

You are right; it won’t work correctly with the multiple-value fields. To exclude the issues with specific labels from the report, please consider creating a new dimension, “My Labels”. This JavaScript dimension will create a string from all the values: Multi values fields include and exclude values - #2 by roberts.cacus

After creating the dimension, you can use it in the Pages, to filter out the issues or use the aggregate in the My Label dimension and then use it in the formulas to get only wanted issues in the report.

You need to decide whether it’s easier to aggregate all the wanted label combinations or better to create the aggregation with exceptions - to exclude certain labels. The formula should look like this:

Aggregate(
Except(
  [My Labels].[My Labels].Members,
  {[My Labels].[asap],
  [My Labels].[asap, plants]}
))

Kindly,
Ilze
support@eazybi.com