A Heatmap color-codes values within a matrix, showing differences through variations in coloring. They are useful for visualizing differences, similarities, and trends across multiple variables. You can quickly add a heatmap to your report via our Visualization selector. If you are specifically looking for a heatmap based on a geographic map, see How to Create a Geographic Map.
This article covers how to make the following heatmaps:
Method 3 - Heatmap with Dendrogram
In Displayr, you can start with a table or crosstab of data, such as this:
and create a heatmap, like this:
Requirements
- You will need a table of data that consists of two or more rows and one or more columns. This can be an R table, summary.table in your Data Sources pane, pasted table, or native drag and drop table.
- The Visualization menu can be accessed via the object inspector on a table, the toolbar (if you are on a Page), and the hover > + menu in the Report tree. Using the object inspector will nest your original table within the visualization itself.
Method 1 - Simple Heatmap
1. Select the table you want to use for your heatmap values.
2. Either in the Report tree hover > + menu or toolbar (if you are on a Page) click Visualization > Heatmap > Heatmap. If accessing via the toolbar, also click on the Page where you'd like to put your Heatmap.
3. Your table will be automatically selected in the object inspector > Data > Data Source > Data field and the heatmap will be created.
Method 2 - Sorted Heatmap
Follow the same process as in Method 1, above, but add the step:
4. Under Chart > Appearance > Row sorting or dendrogram and/or under Chart > Appearance > Column sorting or dendrogram select how you would like to sort the data in the table by selecting Sort by averages (ascending) or Sort by averages (descending).
This example has been sorted using Chart > Appearance > Column sorting or dendrogram > Sort by averages (ascending).
Method 3 - Heatmap with Dendrogram
Follow the same process as in Method 1, above, but add the step:
4. Under Chart > Appearance > Row sorting or dendrogram and/or under Chart > Appearance > Column sorting or dendrogram select how you would like to sort the data in the table by selecting Dendrogram.
The example here has been created by selecting Dendrogram for both rows and columns. It groups together the attributes on the rows and columns by similarity.
Customizing the Heatmap
Use the Chart tab in the object inspector to customize colors, sorting, labeling, legend, axes, hovering and more, see Visualization - Heatmap - Heatmap in the technical reference for more detail.
Next
How to Create a Geographic Map
How to Create a Heatmap using R and HTML
How to Create a Table with Conditional Formatting using R and HTML