Count different issue types in same column

Questions & Answers
,
1

I have 2 different types of projects:

  • QA Projects where testing is done (Test executions are the focus)
  • Main Projects where the business identifies requirements (Stories are the focus)
    I want to see issues that are missing a QA Assignee for the specified issue type based on the project name in the current row. You can see in my table, I’m already counting other missed fields, but they are only important to one or the other. I need help with the code that covers both types in a single column.

image
image424×554 8.81 KB

Non-working code:
CASE WHEN
[Project].CurrentMember.Name matches “QA.*”
THEN
(
[Measures].[Issues created],
[Issue Type].[Test Execution],
[QA Assignee].[(none)]
)
ELSE
(
[Measures].[Issues created],
[Issue Type].[Story],
[QA Assignee].[(none)]
)
END

2

Hi @Camille

Thanks for posting your question!
Would you mind sharing your report definition with us please? Unfortunately from the screenshot you shared, it is difficult to comment why you are not seeing expected results.
Send it directly to support@eazybi.com and refer to this community post.
Export and share the definition for your eazyBI report:
Export and import report definitions

Best wishes,

Elita from support@eazybi.com