Working with Jira Labels and eazyBI

With eazyBI we can create reports in Jira of, for example, “How many issues have one label, or other label, or the two labels at same time“. But sometimes, the Calculated Measure to obtain this is a little bit difficult to extract.

We can try to get the count using tuples.

In Measures creating a Calculate Member for each Label

[Measures].[Label1]=

([Measures].[Issues created count], [Label].[Label1])

[Measures].[Label2]=

([Measures].[Issues created count], [Label].[Label2])

[Measures].[Intersection]=

([Measures].[Issues created count], [Label].[Agregation])

In Labels dimension creating a Calculate Member with the aggregate of the two labels

[Label].[Agregation]=

Aggregate({
[Label].[Label1],
[Label].[Label2]
})

And we can obtain something like this:

But this is not the intersection…it’s the union of the issues with one label and the other one, and we want to count only if the issue have the two labels at same time.

For this reason we can try to “create” a conditional to try to get the value right… something like

[Label].[Intersection2] = 

IIF (IsEmpty([Label].[Label1]) or IsEmpty(
[Label].[Label2]) , null,
1))

We can use as Row the Issue dimension to see if the result is correct and labels with measures dimensions in columns.

Now the result seems to be fine, but the sum/count of the aggregations for time and project is not good… we need something more…

To finish, we must count well the number, and for this reason we need to create a complex formula like this:

[Label].[Label1+Label2]=

NonZero(Count(Filter( Descendants([Issue].CurrentMember, [Issue].[Issue]), DateInPeriod( [Issue].CurrentMember.get(‘Created at’), [Time].CurrentHierarchyMember) AND ([Label].[Label1], [Measures].[Issues created]) > 0 AND ([Label].[Label2], [Measures].[Issues created]) > 0 )))

By MrAddon

Special Thanks to the eazyBI Support Team