Since the 6.0 major version, a new layout is supported to analyze and report saved filter results and all their issue dependencies on a full-featured Pivot Table.
Locations
The Pivot table is available from two locations:
The Jira main menu
2. As a gadget
NOTE: The Pivot table view can be converted into a gadget in a straightforward way by exporting it to a Dashboard.
User Interface & main steps
The pivot table is really user-friendly and intuitive, These are the main steps to work with:
Search Filter: Type a saved filter name
Add Custom Fields: to the dimension list (5)
Include linked issues in the resulting domain: check on this option to include any linked issue (subtasks, core links, Epic, and Portfolio hierarchies) first level into the data set returned by the filter.
Apply: Click on this button to execute the filter and get the issues
Dimensions: A list with all the system and custom (2) fields supported to analyze the issues
Rows and Columns: Drag & drop fields from the dimensions into the rows and columns to build you custom pivot table
Zoom: adjust the pivot table content for the best fitting size that a user feels comfortable with
Aggregator: choose among Count issues or Sum a numeric field.
Links Filter: hide/show link types in the pivot table
Search issue: Search for an issue based on its key or summary and highlight the results on the pivot table
Export: the current pivot table configuration to a Dashboard or Excel
Expand/Collapse: the header to increase the working area
The working area allows users to configure the content by drag&drop dimensions to the rows and columns of the pivot table.
Drill down to issues (cells)
The Pivot table supports Count and Sum numeric and work time issue fields (aggregators)
The aggregator can be changed from the select box (8)
The result is displayed on each cell
Clicking on the aggregated result will open and list the issues of the cell on the Issue Navigator
Hierarchical analysis
The pivot table supports massive analytics of JQL results and it displays the first level (depth =1) of links.
However, the users may want to perform deeper analysis on concrete issues: clicking on the issue key link will open the Tree view dialog for full issue traceability and impact.
Dealing with large and complex data
Highlighting
Frequently a large number of issues and links make the data difficult to read.
To put the focus on a single issue and all its dependencies simply click on the issue item:
This will highlight the target issue and all its dependencies.
Alternatively, you can search for the issue from the select box (10):
