Filter Issues based on component and Status

Questions & Answers
1

I need to filter issues based on specific component and status.

This is the formula I am trying to define under Issue Dimension:
Filter(
[Issue].[Issue].Members,
CoalesceEmpty([issue].CurrentHierarchyMember.get(‘Component IDs’),“”)
MATCHES “.PMO_Resource.”
AND
([Issue].CurrentHierarchyMember.get(‘Status ID’),“”)
MATCHES “.Active.”
)

I only want to see issues with a specific component and in “Active” status. I cant either one to work on its own either.

Should I use aggregate?

Thanks

2

Hi @blabadie

There are several ways how to approach this.
One way would be to import the “Component” custom field as a dimension and then use both the “Component” and the “Status” dimensions in your Pages sections and filter the report by the necessary selections.

component-status
component-status1638×854 85.2 KB

Another option would be to define a new calculated measure in the Measures dimension and use these two dimensions in a tuple together with an existing measure that you would like to see:

(
  [Measures].[Issues created],
  [Component].[PMO_Resource],
  [Status].[Active]
)

​Let me know if this fits your use case or if you have any additional questions!

​Best regards,
​Nauris \ eazyBI support