Provide a management level view of a Work Item with depend Work Items

[Corinne Guibert]

Hello

We are using Jira to manage all our product and project at Company level.

I'm using Plans to provide consolidated view of the projects for a specific domain.

However, my manager things that the view is messy and hard to understand at one glance. Which is not entirely false as we have data coming from multiple Jira Project (or Space) and the overall display of the data in Plans lacks optimization (unless I didn't find the correct option).

Can anyone does a way to have our data displayed in one the kind of format below (it's will end up in a powerpoint:

We have the weeks or months in column, workiitem are can be seen either as a milestone or as a bar and we have a category (the category being taken from the label or for the project name)  in a first column.  The name of the workitem displayed in the bar (as in the left image) allows to gain space 

I'm not sure we can do it with Jira but maybe a solution using an Apps (or a third party solution that can connect to jira ) ?

thanks for any inputs

[Matteo Vecchiato]

Hi @Corinne Guibert , thank you for your question.

In Jira, with out-of-the-box reports is not possible. I would recommend:

1. If in your company is already present Microsoft Powerbi, re-use the skills and know-how to build a report directly in Powerbi.
   The integration with Jira could be through a Powerbi connector (presents in marketplace and to be purchased as a new app). Otherways, the integration could be done via Rest Api.
2. Use Eazybi, one of the most used BI/Graph tools used in Jira, you can see the chart type here: https://eazybi.com/accounts/1000/dashboards/14871-chart-types 
3. Other apps for reporting presents in marketplace, more or less customizables, like "Custom charts for Jira" (link) or other.

I hope it helps.

Regards

[Corinne Guibert]

Hello @Matteo Vecchiato 

I check the last 1 itmes and it's graph and reporting. I'm looking for a planning view.

Can you share any experience on that ?

Thanks

[Matteo Vecchiato]

Sorry but I haven't a direct experience in this kind of report chart.