Pivot Table Gadget
Display Types & Heatmaps
Choose how to visualize the pivot data. The same row/column/aggregation setup can be shown as a table, a heatmap, or a chart.
All 9 Display Types
| Display Type | Description | Best For |
|---|---|---|
| Table | Clean data grid with row/column headers | Exact numbers, large datasets |
| Table Heatmap | Entire table color-coded by value | Quickly spotting high/low values across the whole matrix |
| Table Row Heatmap | Each row independently color-coded | Comparing values within each row |
| Table Column Heatmap | Each column independently color-coded | Comparing values within each column |
| Column Chart | Vertical bar chart from the pivot data | Comparing categories visually |
| Bar Chart | Horizontal bar chart | Long category names that would overflow vertical bars |
| Line Chart | Line series from the pivot data | Trend comparison across multiple series |
| Stacked Area Chart | Stacked area chart | Cumulative composition over time or categories |
| Pie Chart | Pie from the first pivot dimension | Proportion breakdown of a single dimension |
Heatmap Color Schemes
| Color | Best For |
|---|---|
| Red | Risk-oriented reports where more = worse (e.g., open bugs per component) |
| Blue | Neutral, general-purpose comparisons |
| Green | Positive metrics where more = better (e.g., resolved issues per sprint) |
| Grey | Neutral comparisons where color should not imply good or bad |
The shade intensity scales automatically - the lowest value in the dataset gets the lightest shade and the highest gets the darkest.