I’m trying to generate a bug report using the following jql target issues:
type = Bug AND labels IN (1.9-Prod, 1.9PROD_QA) AND status != Done AND priority != Lowest
Because there are two labels, issues with both labels are counted twice. (Even if I use Aggregate, they’re counted twice.)
To prevent duplicate counts, I used the following member formula.
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
(
[Measures].[Issues due],
[Label].[1.9PROD_QA]
) > 0
OR
(
[Measures].[Issues due],
[Label].[1.9-Prod]
) > 0
)
)
However, this method requires a lot of computation, so it takes over a minute to load and doesn’t display properly.
How can I display it properly?
Please help me out!
[Bug Report Example]
