← BACK TO ALL USE CASES
Dashboards & ReportingCustom Jira Reporting

Turn a Jira ticket list into a team × status heat map

Context and Challenge

A technical leader needed to track tickets across different teams and statuses. The goal was to turn the ticket list into a two-dimensional team × status view so stakeholders could quickly see where work was getting stuck and which teams were handling most of the tickets.

To make these patterns visible at a glance, the summary also needed conditional cell formatting that would turn the table into a heat map.

Result

The Jira ticket data is presented as a two-dimensional heat map, with teams on one axis and statuses on the other. Instead of reviewing individual tickets, stakeholders can immediately see which stages contain the most tickets and how the workload is distributed across teams.

Jira ticket heat map in Confluence with teams as rows, statuses as columns, colored ticket counts, and totals.

How it is built

  1. The Jira Issue table is wrapped in Table Filter, which can be used to narrow the data shown in the report.
  2. On top of it, Pivot Table groups the ticket data by responsible team and status.
  3. Table Transformer processes the resulting summary table and applies SQL-based cell formatting to create the heat-map effect.

THE APP MACROS USED

  • Table Filter
  • Pivot Table
  • Table Transformer

CONFLUENCE NATIVE MACROS USED

  • Jira Work Items
← BACK TO ALL USE CASES

Similar use cases

Dashboards & Reporting

Track 40+ Jira projects across multiple business units in one custom report

Consolidate live data from 40+ Jira projects into one cross-project report that makes status differences and overdue work visible across teams.

VIEW CASE → Dashboards & Reporting

Build a data-backed dashboard for 1-on-1 meetings

Bring time-tracking and Jira data into one Confluence page to use as a shared reference during 1-on-1 meetings.

VIEW CASE →

Level up the way your team works in Confluence

Turn your Confluence space into a single source of truth, reduce manual work and copy-paste, and create the visibility your team and stakeholders need.

TRY FREE (opens in a new tab)