Request for Advice: Consolidating Reports in eazyBI from Multiple Jira Projects

Questions & Answers
1

Hello,

We are currently facing a challenge with eazyBI and would appreciate any advice or recommendations from the community.

We have approximately 10 Jira projects, and we have imported data from all these projects into eazyBI. Our goal is to create a consolidated report view that shows data from all projects. However, we are encountering difficulties when it comes to selecting sprints across multiple projects.

Although each project names their sprints with the same name (e.g., APR 1/3), we are unable to select the sprint APR 1/3 in the report view to display data for all projects with the same sprint. Instead, we have to manually select the sprint APR 1/3 for each individual project, which is time-consuming and cumbersome.

If anyone in the community has encountered a similar issue or has any solutions, workarounds, or recommendations on how to efficiently consolidate reports in eazyBI from multiple Jira projects, we would greatly appreciate your input.

Looking forward to your valuable advice and insights.

Best regards,
Paisan.

2

Hi @Paisanc

The Sprint field is a multi-value field in Jira, meaning that any solutions involving hierarchies or similar workarounds are not possible here.

The closest way of grouping these Sprints would be to, for each sprint, create a new calculated member in the Sprint dimension with a formula like this:

Aggregate({
  Filter(
    [Sprint].[Sprint].Members,
    [Sprint].CurrentMember.Name MATCHES "APR 1/3"
  )
})

This member will find and group all the imported sprints that match the specified name. You can use it as a Page filter or in any other way in the report.

This does, however, mean that you have to manually copy and create a member for each sprint by changing the name.

Let me know if this works as expected!
​Best regards,
​Nauris

4

I’ve applied to ‘fix version’ using the formula below, however, the issues with the fix version ‘2024-Apr-26 [2404.1]’ cannot be found as expected.

Aggregate({
Filter(
[Fix Version].[Fix Version].Members,
[Fix Version].CurrentMember.Name MATCHES “2024-Apr-26 [2404.1]”
)
})

Please could anyone kindly advise. Thanks!

5

Hi @Paisanc

Since the MATCHES operator matches the regular expression in the string, you need to adjust it to accommodate the “special symbols” used in this name.

Aggregate({
  Filter(
    [Fix Version].[Fix Version].Members,
    [Fix Version].CurrentMember.Name MATCHES "2024-Apr-26 \[2404.1\]"
  )
})

If you wish to match to the exact name, you can use the “=” instead of the “MATCHES” operator:

Aggregate({
  Filter(
    [Fix Version].[Fix Version].Members,
    [Fix Version].CurrentMember.Name = "2024-Apr-26 [2404.1]"
  )
})

​Best regards,
​Nauris

6

Thanks for your kind advice. It’s working now. Thanks!

1 Like