Average resolution workdays filtering issues that do not contain any labels

Hello,

I need a report to show average resolution workdays filtering issues that do not contain any specific labels (for example “A, B”).

I need to create this user defined measure.

Can you help me ?

Thank you very much

Can anyone help me please ?

Hi,

This use case requires using the Avg function and filtering the issues with the appropriate condition:

Avg(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  not CoalesceEmpty([Measures].[Issue labels],"") MATCHES
   '.*(^|,)(A|B)($|,).*'
  ),
  [Measures].[Total resolution workdays]
)

Note that the issues are filtered by searching the pattern in the label comma list. So, please, use the appropriate labels in the regular expression.

Kindly,
Janis, eazyBI support

1 Like

It works janis.plume. Thank you very much

1 Like