How to see projects related to initiatives through a linked epic?

[Scott Federman]

I have epics across multiple projects. I have Initiatives in a single separate project. The epics across multiple projects are linked the an initiative. I want to be able to create a filter for a gadget in a dashboard that shows the initiatives with a list of related projects that the linked epics belong to. So it would show a single epic with multiple projects linked to it by  way of epic issue type. Also we use plans so epics are linked to initiatives using parent field. Is this possible?

[Hannes Obweger - JXL for Jira]

Hi @Scott Federman

this is a tricky one - I couldn't think of a perfect solution, but I think you could get reasonably close with the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including the support for issue hierarchies, as well as issue grouping by any field. With these two combined, you could easily create a view like this (highlighted in teal are my initiatives):

What's happening here is that I'm viewing my issues in a their initiative/epic/etc. hierarchy, with an additional grouping of epics by project (plus I'm using conditional formatting to highlight the initiatives). As you can see above, I can drill down into my issues and make changes straight in JXL - but you obviously don't have to do that.

Any questions just let me know,

Best,

Hannes