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
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
It works janis.plume. Thank you very much