Pivot Tables, Charts & Heatmaps is a Jira dashboard app that helps teams transform Jira work-item data into configurable, multidimensional reports and visualizations.
Group and visualize work items by project, status, assignee, priority, sprint, epic or other Jira fields; calculate counts, totals, percentages, averages, and display the results as pivot tables, heatmaps or charts of various type. The app makes it easier to analyze complex Jira data directly on your dashboard without exporting it to a spreadsheet
The app helps you answer questions such as:
-
How is work distributed across projects, teams, statuses or assignees?
-
How many work items or Story Points are included in each category?
-
What percentage of an epic, project or initiative is complete?
-
How does workload compare across team members?
-
Which projects, priorities or work item types contain the most work?
-
How are work items distributed across sprints, months, quarters or years?
-
What are the customer satisfaction, sentiment or approval results for service projects?
-
Which Jira work items contribute to a particular value in the report?
Key features
Pivot tables and charts in one gadget
Display the same Jira data in different formats depending on how you want to analyze or present it:
-
Regular pivot table
-
Table heatmap
-
Stacked and grouped column charts
-
Stacked and grouped bar charts
-
Line charts
-
Dot charts
-
Area charts
-
Scatter charts
-
Pie charts
Use tables and heatmaps for detailed analysis, or charts for a more visual summary suitable for dashboards and stakeholder reporting.
Drag-and-drop report configuration
Create multidimensional reports by dragging Jira fields into the table rows and columns. This makes it easy to reorganize the report and examine the same data from different perspectives.
For example, you can analyze:
-
Project by status
-
Assignee by priority
-
Epic by status category
-
Sprint by assignee
-
Work item type by project
-
Created month by project
Multiple data sources
Create reports using work items returned by:
-
Saved filters
-
JQL queries
-
Epics
-
Portfolio-level work items, such as initiatives or themes
Saved filters and JQL queries can include work from multiple projects or teams, allowing you to create consolidated reports for programs, departments or portfolios.
Flexible calculations
Configure the gadget to:
-
Count work items
-
Sum Story Points
-
Sum Original Time Estimates
-
Sum other numerical Jira fields
-
Display values as a fraction or percentage of their row
-
Add total rows and columns
-
Add percentage columns
This allows the same gadget to support both simple work-item counts and more detailed effort or progress reports.
Reporting with standard and custom Jira fields
Break down your data using a wide range of Jira fields, including:
-
Project
-
Status and status category
-
Work item type
-
Assignee
-
Reporter
-
Priority
-
Resolution
-
Sprint
-
Components
-
Labels
-
Fix versions
-
Created and resolution dates
-
Numerical custom fields
You can also use supported hierarchy fields, such as parent epic or higher-level portfolio work items, to create reports across multiple planning levels.
Project, epic and portfolio reporting
Monitor progress at different levels of your organization. For example, you can report on:
-
Project completion by status category
-
Epic progress by work-item count or Story Points
-
Initiative or theme progress
-
Work distribution across multiple projects
-
Progress by team, release or portfolio item
These reports provide a summarized view of current Jira data while preserving the connection to the underlying work items.
Jira Service Management insights
Create pivot reports using supported Jira Service Management fields, including:
-
Customer satisfaction
-
Customer sentiment
-
Approval status
-
Approvers
These dimensions can help service teams compare feedback, requests and approval outcomes across projects, request types, assignees or other relevant categories.
Heatmaps for identifying concentrations
Use table, row or column heatmaps to highlight larger and smaller values visually. Heatmaps make it easier to identify workload concentrations, dominant categories and unusual distributions within larger reports.
Access to the underlying Jira work items
Where supported by the selected configuration, table values are clickable and open the Jira work items that contribute to that result. This allows users to move from a summarized report to the relevant work-item details.
Subtask support
Include subtasks associated with the work items returned by the selected data source, allowing the report to provide a more complete view of the work included in a project or initiative.