Hi jwilkinson,
Welcome to the eazyBI community!
We don’t recommend mixing dimensions (like Label) when defining Project dimension members. This approach can lead to unexpected results and performance issues.
Instead, we recommend using calculated measures to handle the logic. Here’s a general way how you could approach it:
([Measures].[Your measure],
[Project].[Project A],
[Label].[Project A labels]) -- aggregated member* in Label dimension
+
([Measures].[Your measure],
[Project].[Project B])
*To group all Project A labels into one member, create and aggregated member in the Labels dimension.
Another options to consider:
- Use JavaScript: You could create a new dimension as JavaScript calculated field in the import options that returns
"Valid"or"Yes"or other specific value for issues that are either from Project A with matching labels or from Project B. Here is a similar example. This would let you use a single value in your report formulas and filters! - Use JQL: In case your account includes only Project A and Project B, and you always want to limit Project A only to specific labels in this account, you could use a JQL import filter - though this is likely a less common scenario.
Let me know if you have additional questions on any of this.
Best,
Ilze