Create a Risk-Impact Heat Map

Date de publication : 13 Jul 2015
Date de dernière modification : 20 Jul 2023

Question

How to create a heat map that demonstrates risk impact.

Environnement

Tableau Desktop

Réponse

Option 1

Use a background image of the gradient under a previously created scatter plot. For more information, see Background Images.

Option 2

Use table calculations to fill in the view even when no data exists. The following instructions use bins to create discrete dimensions and can be reviewed in the attached workbook.

Step 1: Create the Base View

Right-click on Risk and select Create > Bins….
Set the Size of bins to 10 and click OK.
Right-click on Impact and select Create > Bins….
Set the Size of bins to 10 and click OK.
Drag Risk (bin) to the Rows shelf and Impact (bin) to the Columns shelf.
Right-click on Risk (bin) on the Rows shelf and select Sort.
Select Descending and click OK.
Right-click and drag Name from Dimensions to the Label card.
Right-click Name on the Label card and select Measure > Count (Distinct).

Step 2: Create the Color Measure

Create the following calculated fields:
- Name: hIndex Formula: INDEX()
- Name: vIndex Formula: 1 + SIZE() - INDEX()
- Name: xSumIndex Formula: [hIndex] + [vIndex]

Drag xSumIndex to the Color card.
Right-click on xSumIndex on the Marks card and select Edit Table Calculation….
From the Calculated Field drop-down menu, select vIndex.
From the Compute Using drop-down menu, select Table (Down).
From the Calculated Field drop-down menu, select hIndex.
From the Compute Using drop-down menu, select Table (Across).
Click OK.
On the Marks card, click the Color and select Edit Colors….
Select Red-White-Green Diverging from the Palette drop-down menu.
Click Reversed.
Click OK.