Calculated Project member with or without labels

Questions & Answers
1

I have an unfortunate scenario where users are slicing data inside a project using labels. They want to see that segment of data alongside the data from another project (with any label) as one single aggregated data set.

I was able to do this in the issue dimension in measures, but is there a way to add a calculated member in the Project dimension that accomplishes this? It would be an aggregate of two projects, but with issue label filtering on one using “contains.”

2

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