EazyBI Table Reporting - 1 Epic, Multiple Projects Causing Epic Duplication

Hi,
Let me try and explain this as best as I can!

I have 3 Jira projects as follows:
Project FPS - This contains my Epics
Project FSPE - This contains user stories for Team A
Project FSDI - This contains user stories for Team B

As you can see below Team A and Team B need to complete user stories relating to the same epic. So essentially, my FSPE & FSDI Projects are reporting up, to Epics in my FPS project.

MY PROBLEM: What I want to achieve in my table below is to see the total rolled up progress% against epic FPS-13174. However, as you can see Eazy BI is duplicating Epic FPS-13174 because it has a child user story from 2 different Jira projects.

MY QUESTION: How can I get the epic to appear once and indent all user stories from both project below it?

BTW, This is not a an issue when I have 2 child user stories from 1 project.

Any help appreciated!

Hi @Liam_Nolan

Welcome to the eazyBI community!

You may want to invent a new hierarchy in the Issue dimension without project level, so the issues from all projects would be listed below the epic issue, which appears once. Read here how to build such a hierarchy:
https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/additional-issue-hierarchies#AdditionalIssuehierarchies-Epichierarchywithoutprojects

Best
IlzeLA, support@eazybi.com