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
In heatmap display types, choose the base color that fits the meaning of your data:
| 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. This happens per table, per row, or per column depending on the heatmap type you choose.
Switching Display Types
You can change the display type at any time without reconfiguring your fields or aggregation. The same data renders in the new format instantly in the live preview.