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:
DateParse((Tail(
  Order(
   Filter(
      Descendants([Issue].CurrentMember,[Issue].[Issue]),
       NOT IsEmpty([Measures].[Issue Start Date])
       )
       ,[Measures].[Issue Start Date]
       ,DESC)).Item(0),
     [Measures].[Issue Start Date]))
The result must be expressed in ISO Date.
  • 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.

unnamed

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!

 

Posted by:.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s