JIRA Product Management

The JIRA Product Management app downloads and analyzes issue tickets on a JIRA server. 

Infographic

The infographic provides five widgets:

• Reporter to Assignee. This circular network chart shows the relationships between who is reporting tickets and who those tickets are assigned to.
• Open Tickets Year-To-Date. This chart plots the distribution of open tickets over time.
• Duration until Ticket is Closed. This graph shows how many tickets are resolved within a specific number of days, ranging from zero to fifty days.
• Description Word Cloud. This cloud shows which words occur most frequently in ticket descriptions. The larger the word, the more time it appears.
• Ticket Types. This pie chart shows the distribution of tickets by type at your company.

Connection and Import

The data is imported using the Ticket import job, which is based on the JiraConnection connector. You can change the setting in the connector to configure a different JIRA server. For the public apache.org JIRA server, select the following settings:

In the two import jobs, you can configure, which tickets should be selected for the analysis. For example, if you configure the "Ticket" import job to use the query 

project="HADOOP" AND created >= "2008/01/01",

The app fetches all tickets in the HADOOP project which where created after January 1st, 2008. 

Workbook

The analysis for the infographic is performed in the Tickets workbook. The IssueType sheet uses GROUPBY to distinguish different types of tickets from each other, while the Assignments sheet does the same for ticket assignees. Those assignees are then sorted on the Top200Assignee sheet. Analysis for the word cloud is done in the sheets that include "Word" in the title. Ticket information is grouped and tokenized in other sheets to create the widgets analyzing tickets.