How to create a Gantt report to track/plan Projects with Jira and EazyBI

In this article I want to show you how to track/plan a list of Projects of Jira with the plugin EazyBI. And… it’s very easy!

We have two possibilities to track the Start Date of a project:

• We can create a custom field of type “Date” and show that field in the screen of the ticket
• We can consider as “Start Date” the first date of the first transition.

To track the End Date we can consider to use the standard field “Due Date”.

To start the Gantt report in EazyBI, we can put “Issues” as rows (the Issues will be merged in “Project Names“), and “Measures” as columns. Then we create two “Calculated Measures” to track the Start Date and End Date of the project (as you know, this is mandatory in Gantt reports).

We can consider the Start Date of the report as:

• The Min ( [Issue].[StartDate_customfield]). Then the formula is:

• Or we can consider the Start Date as the first Date of the first Transition of the Issues. Then the formula is:

[Measures].[Transition to status first date]

For the End Date we consider as the Max([Issue].[Due Date]). Then the formula is:

DateParse((Tail(
Order(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
NOT IsEmpty([Measures].[Issue due date])
)
,[Measures].[Issue due date]
)).Item(0),
[Measures].[Issue due date]))

As we can see, track and plan projects is very easy in EazyBI, also we can do ZOOM in the project and see the plan for each ticket.

If you combine the power of EazyBI in Jira, with other fantastic plugins like JExcel of Profields your reports will be awesome! sure!

Many thanks to the EazyBI support team for your help!