Use case to have a specific project and include work from other projects with specific label

I have a use case that requires a report that includes all work in a specific project, as well as all other work in other projects labeled with a particular value.

Hi, @briantaylor

Welcome to the eazyBI community.

Please consider creating a calculated measure that combines work from your specific project with work from other projects having a particular label.

Here’s the formula approach:

(
[Project].[Your Specific Project],
[Measures].[Hours spent]
)
+
Sum(
Filter(
[Project].[Project].Members,
[Project].CurrentMember.Name <> "Your Specific Project"
),
(
[Label].[Your Specific Label],
[Measures].[Hours spent]
)
)

Alternative approach: If you prefer filtering at import level, you can create a separate eazyBI account with a JQL filter like:

project = "YourProject" OR labels = "YourLabel"

This would import only the relevant data and simplify your reporting. Please read more about JQL here: Data from Jira

Kindly,
Ilze