Answer

Option 1

Option 2

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

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

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