Filter Issues based on component and Status

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

This is the formula I am trying to define under Issue Dimension:
CoalesceEmpty([issue].CurrentHierarchyMember.get(‘Component IDs’),“”)
MATCHES “.PMO_Resource.
([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?


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.

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],

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

​Best regards,
​Nauris \ eazyBI support