I'm trying to show the TOTAL # of open issues with a specific component but my query is only returning a small amount

Questions & Answers
1

This is my user defined measure.

(([Project].[Hotfix].[API]))
[Measures].[Open issues]

Except(
[Status].[Status].Members,
[Status].[Cancelled]
[Status].[Done]
)

I have my report broken down by month and the results are only showing what issues were opened with the defined component in the given month rather than the total amount of issues.

I’m trying to build a Kanban report that shows the total issues by component and how many my team has completed in a given month.

2

Hi @gsirris

Welcome to eazyBI community!

I recommend using a Tuple (Tuple) function in your use-case. Please try the formula below and see if it returns the expected results.

(
  [Measures].[Open issues],
  [Project].[Hotfix].[API],
  [Resolution].[(unresolved)]
)

Best wishes,

Elita from support@eazybi.com