Labels create except some labels

Questions & Answers
,
1

Hello!

“How can I create a metric in eazyBI that considers all labels except those starting with ‘GV’?”

2

Hi @Viviane_Da_Silva_Mor

You can do the following:
In the Label Dimension, create a new Calculated Member:

Aggregate(
  Except(
    [Label].[Label].Members,
    Filter(
      [Label].[Label].Members,
      [Label].CurrentMember.Name MATCHES 'GV+'
    )
  )
)

When selected, this will return all Labels that don’t start with GV

3

Hello @Viviane_Da_Silva_Mor,

The Labels is a multi-value dimension that has some implications in cases of overlapping selections.
Multiple solutions are only relevant to specific use cases.

  1. display details for individual labels compliant with the specific condition - the option suggested by @Amit_Shil works great
  2. display count of issues that (do not) comply with specific conditions - the suggestion by @Amit_Shil , but with distinct issue count measures. Please see more here - Jira Core measures and dimensions
  3. show average or total values for issues not having the specific labels - some ideas are described
    here - Find all issues without some labels - #4 by Freddy_Salome
    or here - Multi labels dimension table - #3 by zane.baranovska

The flexibility provided by free-text fields in Jira leads to some complexity in processing that data in reports. Please share more details about your ultimate use case to suggest the most convenient approach.

Regards,
Oskars / support@eazyBI.com