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:

unnamed

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…

unnamed (1).png

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

Advertisements
Posted by:.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s