Filter for epic's project

Hi! I’m new to eazyBI and started with demo reports. Issue Epic Gantt Chart is excellent but I am looking to filter the results based on the epic’s project. In the demo report, the epic and children belong to the same project. In our case, epics are in another project and children in another. So if I use the project filter in the report, it will filter out the children. Appreciate any help :slight_smile:

Hi, @SuviR

Welcom to the eazyBI community.
The easiest way would be to import a new epic-level dimension, “Epic project,” which would copy the project from Epic to its children.

That would let you filter the report by the “Epic project” dimension instead of using the “Project” dimension, which would filter all issues by their own project details.

If you need this dimension just in one eazyBI account, I would recommend defining a new account-specific calculated field
See a similar example here: Epic level custom field

Kindly,
Ilze

1 Like

Thank you for the tip! This really helped :sunny: