Pivot Table Gadget

Pivot Table Gadget

The Pivot Table gadget lets you summarize Jira issues in a cross-tabulation format. Group issues by multiple fields on both rows and columns simultaneously, then aggregate by count, sum, average, minimum, or maximum. Visualize the results as a data table, heatmap, or chart.

Use this section to learn how to configure row/column grouping, choose an aggregation method, and get the most from the display types.

In This Section

Page NameDescription
OverviewWhat the Pivot Table does, data sources, and common use cases with examples.
Row & Column FieldsHow to add, order, and nest up to 3 fields per axis for multi-level grouping.
Aggregation MethodsAll 7 aggregation methods - Count, Sum, Average, Min, Max, Count%, Sum% - and when to use each.
Display Types & HeatmapsAll 9 display types including heatmaps and chart options, plus heatmap color selection.
Totals, Formatting & ExportSummary rows/columns, percentage and average columns, date formatting, drill-through, and export.